Chip 2006 December

home *** CD-ROM | disk | FTP | other *** search

/ Chip 2006 December / chip-cd_2006_12.zip / 12 / Biuro / Statlook2 Master / statlook2.msi / Data1.cab / sql_mssql.ucf < prev next >

Wrap

Text File | 2006-07-14 | 123KB | 953 lines

// // uplook SQL Configuration File for Microsoft SQL Provider // // Copyright ⌐ 2002 - 2005, A plus C Sp. z o.o. // // Constants section SQL_TRUE "1" SQL_FALSE "0" SQL_NULL "NULL" // Table names section SQL_TABLE_FORMAT_1000 "[_Anubis_Master_1000_]" SQL_TABLE_FORMAT "[_Anubis_Master_2000_]" SQL_TABLE_USERGROUP "[UserGroup]" SQL_TABLE_USER "[User]" SQL_TABLE_NETWORK "[Network]" SQL_TABLE_SCANRESULT "[ScanResult]" SQL_TABLE_SCANAPPINFO "[ScanAppInfo]" SQL_TABLE_LICENSES "[Licenses]" SQL_TABLE_RIGHTS "[Rights]" SQL_TABLE_WINSESSION "[WinSession]" SQL_TABLE_APPSESSION "[AppSession]" SQL_TABLE_APPSESSIONSUM "[AppSessionSum]" SQL_TABLE_UNKNOWNAPP "[UnknownApp]" SQL_TABLE_UNKNOWNAPPINFO "[UnknownAppInfo]" SQL_TABLE_APPALIAS "[AppAlias]" SQL_TABLE_APP "[App]" SQL_TABLE_SCANREGINFO "[ScanRegInfo]" SQL_TABLE_KNOWNAPP "[KnownApp]" SQL_TABLE_SCANREGCOMPONENT "[ScanRegComponent]" SQL_TABLE_SCANSYSTEMINFO "[ScanSystemInfo]" SQL_TABLE_WEBSESSION "[WebSession]" SQL_TABLE_WEBTIME "[WebTime]" SQL_TABLE_WEBSITE "[WebSite]" SQL_TABLE_SCANFILEGROUP "[ScanFileGroup]" SQL_TABLE_SCANFILEINFO "[ScanFileInfo]" SQL_TABLE_ICON "[Icon]" // Field name section SQL_FIELD_NONET "[NoNet]" SQL_FIELD_HARDWARE "[Hardware]" SQL_FIELD_NOPRINT "[NoPrint]" SQL_FIELD_ID "[Id]" SQL_FIELD_IDSCAN "[IdScan]" SQL_FIELD_ATTR "[Attr]" SQL_FIELD_IDAPP "[IdApp]" SQL_FIELD_OMIT "[Omit]" SQL_FIELD_IDREG "[IdReg]" SQL_FIELD_DESC "[Desc]" SQL_FIELD_IDPACKET "[IdPacket]" SQL_FIELD_FILESIZE "[FileSize]" SQL_FIELD_NOVERSION "[NoVersion]" SQL_FIELD_IDUSER "[IdUser]" SQL_FIELD_NAME "[Name]" SQL_FIELD_IDSESSION "[IdSession]" SQL_FIELD_IDSITE "[IdSite]" SQL_FIELD_EXTRA1 "[Extra1]" SQL_FIELD_LABEL1 "[Label1]" SQL_FIELD_IDGROUP "[IdGroup]" SQL_FIELD_CRC "[CRC]" SQL_FIELD_MD5 "[MD5]" SQL_FIELD_PRODUCTKEY "[ProductKey]" SQL_FIELD_DNSNAME "[DNSName]" SQL_FIELD_CONNECTMODE "[ConnectMode]" SQL_FIELD_MAC "[Mac]" SQL_FIELD_COMPANYNAME "[CompanyName]" SQL_FIELD_FIRSTID "[FirstId]" SQL_FIELD_SITERANK "[SiteRank]" SQL_FIELD_ICON "[IdIcon]" // Update relations section SQL_RELATION_SCANRESULT_SCANREGINFO "ScanRes_ScanRegInfo" SQL_RELATION_SCANAPPINFO_KNOWNAPP "ScanAppInfo_KnownApp" SQL_RELATION_RIGHTS_KNOWNAPP "Rights_KnownApp" SQL_RELATION_SCANREGINFO_SCANREGCOMPONENT "ScanRegInfo_ScanRegComponent" SQL_RELATION_SCANAPPINFO_SCANREGINFO "ScanAppInfo_ScanRegInfo" SQL_RELATION_UNKNOWNAPPINFO_SCANREGINFO "UnknownAppInfo_ScanRegInfo" SQL_RELATION_SCANRESULT_SCANSYSTEMINFO "ScanRes_ScanSysInfo" SQL_RELATION_USER_WEBSESSION "User_WebSession" SQL_RELATION_WEBSESSION_WEBTIME "WebSession_WebTime" SQL_RELATION_WEBTIME_WEBSESSION "WebTime_WebSite" SQL_RELATION_SCANRESULT_SCANFILEGROUP "ScanResult_ScanFileGroup" SQL_RELATION_SCANFILEGROUP_SCANFILEINFO "ScanFileGroup_ScanFileInfo" SQL_RELATION_ICON_SCANAPPINFO "Icon_ScanAppInfo" SQL_RELATION_ICON_UNKNOWNAPPINFO "Icon_UnknownAppInfo" SQL_RELATION_ICON_SCANFILEINFO "Icon_ScanFileInfo" SQL_RELATION_ICON_UNKNOWNAPP "Icon_UnknownApp" // Update database section SQL_CREATE_SCANREGINFO "CREATE TABLE [ScanRegInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [NoPrint] BIT, [Name] VARCHAR(128), [Version] VARCHAR(64), [ProductID] VARCHAR(64), [Publisher] VARCHAR(64), [InstallDate] INTEGER );CREATE INDEX [IdScan] ON [ScanRegInfo] ( IdScan ASC );CREATE INDEX [NoPrint] ON [ScanRegInfo] ( [NoPrint] );ALTER TABLE [ScanRegInfo] ADD CONSTRAINT ScanRes_ScanRegInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_ATTR_IN_SCANAPPINFO "ALTER TABLE [ScanAppInfo] ADD [Attr] IMAGE" SQL_CREATE_ATTR_IN_UNKNOWNAPPINFO "ALTER TABLE [UnknownAppInfo] ADD [Attr] IMAGE" SQL_CREATE_NOPRINT_IN_UNKNOWNAPPINFO "ALTER TABLE [UnknownAppInfo] ADD [NoPrint] BIT;CREATE INDEX [NoPrint] ON [UnknownAppInfo] ( [NoPrint] )" SQL_CREATE_NOPRINT_IN_SCANAPPINFO "ALTER TABLE [ScanAppInfo] ADD [NoPrint] BIT;CREATE INDEX [NoPrint] ON [ScanAppInfo] ( [NoPrint] )" SQL_CREATE_HARDWARE_IN_SCANRESULT "ALTER TABLE [ScanResult] ADD [Hardware] IMAGE" SQL_CREATE_HARDWARE_IN_USER "ALTER TABLE [User] ADD [Hardware] IMAGE" SQL_CREATE_NONET_IN_USER "ALTER TABLE [User] ADD [NoNet] BIT;CREATE INDEX [NoNet] ON [User] ( [NoNet] )" SQL_CREATE_KNOWNAPP "CREATE TABLE [KnownApp] ( [Id] INTEGER PRIMARY KEY NOT NULL, [Company] VARCHAR(128), [Name] VARCHAR(128), [Version] VARCHAR(64), [ExeName] VARCHAR(64) );CREATE UNIQUE INDEX [Id] ON [KnownApp] ( Id ASC );CREATE INDEX [Company] ON [KnownApp] ( Company ASC );CREATE INDEX [Name] ON [KnownApp] ( Name ASC );CREATE INDEX [Version] ON [KnownApp] ( Version ASC );CREATE INDEX [ExeName] ON [KnownApp] ( ExeName ASC );CREATE INDEX [Main] ON [KnownApp] ( [Company], [Name], [Version] )" SQL_CREATE_OMIT_IN_SCANAPPINFO "ALTER TABLE [ScanAppInfo] ADD [Omit] BIT;CREATE INDEX [Omit] ON [ScanAppInfo] ( [Omit] )" SQL_CREATE_OMIT_IN_UNKNOWNAPPINFO "ALTER TABLE [UnknownAppInfo] ADD [Omit] BIT;CREATE INDEX [Omit] ON [UnknownAppInfo] ( [Omit] )" SQL_CREATE_SCANREGCOMPONENT "CREATE TABLE [ScanRegComponent] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdReg] INTEGER NOT NULL, [Path] VARCHAR(255) );CREATE INDEX [IdReg] ON [ScanRegComponent] ( IdReg ASC );CREATE INDEX [Path] ON [ScanRegComponent] ( [Path] );ALTER TABLE [ScanRegComponent] ADD CONSTRAINT ScanRegInfo_ScanRegComponent FOREIGN KEY ( [IdReg] ) REFERENCES [ScanRegInfo] ( [Id] )ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_DESC_IN_SCANRESULT "ALTER TABLE [ScanResult] ADD [Desc] NTEXT" SQL_CREATE_IDPACKET_IN_SCANAPPINFO "ALTER TABLE [ScanAppInfo] ADD [IdPacket] INTEGER;CREATE INDEX [IdPacket] ON [ScanAppInfo] ( [IdPacket] )" SQL_CREATE_IDPACKET_IN_UNKNOWNAPPINFO "ALTER TABLE [UnknownAppInfo] ADD [IdPacket] INTEGER;CREATE INDEX [IdPacket] ON [UnknownAppInfo] ( [IdPacket] )" SQL_CREATE_FILESIZE_IN_UNKNOWNAPP "ALTER TABLE [UnknownApp] ADD [FileSize] INTEGER" SQL_CREATE_NOVERSION_IN_UNKNOWNAPP "ALTER TABLE [UnknownApp] ADD [NoVersion] BIT;CREATE INDEX [NoVersion] ON [UnknownApp] ( [NoVersion] );DROP INDEX [UnknownApp].[Main]" SQL_CREATE_SCANSYSTEMINFO "CREATE TABLE [ScanSystemInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [Name] VARCHAR(128), [Version] VARCHAR(32), [Compilation] VARCHAR(128), [IdProduct] VARCHAR(128) );CREATE INDEX [IdScan] ON [ScanSystemInfo] ( IdScan ASC );CREATE INDEX [Name] ON [ScanSystemInfo] ( Name ASC );CREATE INDEX [Version] ON [ScanSystemInfo] ( Version ASC );CREATE INDEX [Compilation] ON [ScanSystemInfo] ( Compilation ASC );ALTER TABLE [ScanSystemInfo] ADD CONSTRAINT ScanRes_ScanSysInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_NOPRINT_IN_SCANREGINFO "ALTER TABLE [ScanRegInfo] ADD [NoPrint] BIT;CREATE INDEX [NoPrint] ON [ScanRegInfo] ( [NoPrint] )" SQL_CREATE_WEBSESSION "CREATE TABLE [WebSession] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdUser] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [UserName] VARCHAR(128) );CREATE INDEX [IdUser] ON [WebSession] ( IdUser ASC );CREATE INDEX [Start] ON [WebSession] ( Start ASC );CREATE INDEX [UserName] ON [WebSession] ( UserName ASC );ALTER TABLE [WebSession] ADD CONSTRAINT User_WebSession FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_WEBTIME "CREATE TABLE [WebTime] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdSession] INTEGER NOT NULL, [IdSite] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [WorkTime] INTEGER NOT NULL );CREATE INDEX [IdSession] ON [WebTime] ( IdSession ASC );CREATE INDEX [IdSite] ON [WebTime] ( IdSite ASC );CREATE INDEX [Start] ON [WebTime] ( Start ASC );CREATE INDEX [WorkTime] ON [WebTime] ( WorkTime ASC );ALTER TABLE [WebTime] ADD CONSTRAINT WebSession_WebTime FOREIGN KEY ( [IdSession] ) REFERENCES [WebSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_WEBSITE "CREATE TABLE [WebSite] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [URL] VARCHAR(255) NOT NULL, [Title] VARCHAR(255) );CREATE UNIQUE INDEX [URL] ON [WebSite] ( URL ASC );CREATE INDEX [Title] ON [WebSite] ( Title ASC )" SQL_CREATE_EXTRA_IN_SCANRESULT "ALTER TABLE [ScanResult] ADD [Extra1] VARCHAR(255), [Extra2] VARCHAR(255), [Extra3] VARCHAR(255), [Extra4] VARCHAR(255), [Extra5] VARCHAR(255)" SQL_CREATE_EXTRALABEL_IN_SCANRESULT "ALTER TABLE [ScanResult] ADD [Label1] VARCHAR(64), [Label2] VARCHAR(64), [Label3] VARCHAR(64), [Label4] VARCHAR(64), [Label5] VARCHAR(64)" SQL_CREATE_SCANFILEGROUP "CREATE TABLE [ScanFileGroup] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [Name] VARCHAR(255) NOT NULL );CREATE INDEX [IdScan] ON [ScanFileGroup] ( IdScan ASC );CREATE INDEX [Name] ON [ScanFileGroup] ( Name ASC );ALTER TABLE [ScanFileGroup] ADD CONSTRAINT ScanResult_ScanFileGroup FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE" SQL_CREATE_SCANFILEINFO "CREATE TABLE [ScanFileInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [IdGroup] INTEGER NOT NULL, [Path] VARCHAR(255) NOT NULL, [Name] VARCHAR(32) NOT NULL, [NoPrint] BIT, [SizeLow] INTEGER NOT NULL, [SizeHigh] INTEGER NOT NULL, [Created] DATETIME, [Accessed] DATETIME, [Wrote] DATETIME, [Type] VARCHAR(64), [Ext] VARCHAR(16), [IdIcon] INTEGER );CREATE INDEX [IdScan] ON [ScanFileInfo] ( IdScan ASC );CREATE INDEX [IdGroup] ON [ScanFileInfo] ( IdGroup ASC );CREATE INDEX [NoPrint] ON [ScanFileInfo] ( NoPrint ASC );CREATE INDEX [Name] ON [ScanFileInfo] ( [Name] );CREATE INDEX [Path] ON [ScanFileInfo] ( [Path] );CREATE INDEX [Type] ON [ScanFileInfo] ( [Type] );CREATE INDEX [FileSize] ON [ScanFileInfo] ( [SizeHigh], [SizeLow] );CREATE INDEX [Created] ON [ScanFileInfo] ( [Created] );CREATE INDEX [Accessed] ON [ScanFileInfo] ( [Accessed] );CREATE INDEX [Wrote] ON [ScanFileInfo] ( [Wrote] );CREATE INDEX [IdIcon] ON [ScanFileInfo] ( [IdIcon] );ALTER TABLE [ScanFileInfo] ADD CONSTRAINT ScanFileGroup_ScanFileInfo FOREIGN KEY ( [IdGroup] ) REFERENCES [ScanFileGroup] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE [ScanFileInfo] ADD CONSTRAINT Icon_ScanFileInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE" SQL_CREATE_CRC_IN_UNKNOWNAPP "ALTER TABLE [UnknownApp] ADD [CRC] INTEGER;CREATE INDEX [CRC] ON [UnknownApp] ( [CRC] )" SQL_CREATE_MD5_IN_UNKNOWNAPP "ALTER TABLE [UnknownApp] ADD [MD5] VARCHAR(40);CREATE INDEX [MD5] ON [UnknownApp] ( [MD5] )" SQL_CREATE_PRODUCTKEY_IN_SCANSYSTEMINFO "ALTER TABLE [ScanSystemInfo] ADD [ProductKey] VARCHAR(64);CREATE INDEX [ProductKey] ON [ScanSystemInfo] ( [ProductKey] )" SQL_CREATE_DNSNAME_IN_USER "ALTER TABLE [User] ADD [DNSName] VARCHAR(255);CREATE INDEX [DNSName] ON [User] ( [DNSName] )" SQL_CREATE_CONNECTMODE_IN_USER "ALTER TABLE [User] ADD [ConnectMode] INTEGER" SQL_CREATE_MAC_IN_USER "ALTER TABLE [User] ADD [Mac] VARCHAR(32);CREATE INDEX [Mac] ON [User] ( [Mac] )" SQL_CREATE_ICON "CREATE TABLE [Icon] ( [Id] INTEGER NOT NULL PRIMARY KEY, [Icon] IMAGE NOT NULL )" SQL_CREATE_IDICON_IN_SCANAPPINFO "ALTER TABLE [ScanAppInfo] ADD [IdIcon] INTEGER;CREATE INDEX [IdIcon] ON [ScanAppInfo] ( [IdIcon] );ALTER TABLE [ScanAppInfo] ADD CONSTRAINT Icon_ScanAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE;" SQL_CREATE_IDICON_IN_UNKNOWNAPPINFO "ALTER TABLE [UnknownAppInfo] ADD [IdIcon] INTEGER;CREATE INDEX [IdIcon] ON [UnknownAppInfo] ( [IdIcon] );ALTER TABLE [UnknownAppInfo] ADD CONSTRAINT Icon_UnknownAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE;" SQL_CREATE_IDICON_IN_SCANFILEINFO "ALTER TABLE [ScanFileInfo] ADD [IdIcon] INTEGER;CREATE INDEX [IdIcon] ON [ScanFileInfo] ( [IdIcon] );ALTER TABLE [ScanFileInfo] ADD CONSTRAINT Icon_ScanFileInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE;" SQL_CREATE_IDICON_IN_UNKNOWNAPP "ALTER TABLE [UnknownApp] ADD [IdIcon] INTEGER;CREATE INDEX [IdIcon] ON [UnknownApp] ( [IdIcon] );ALTER TABLE [UnknownApp] ADD CONSTRAINT Icon_UnknownApp FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE;" // Query section SQL_QUERY_NETTREE "( SELECT [Network].[Id] AS [IdNetwork], [Network].[Name] AS [NameNetwork], [UserGroup].[Id] AS [IdGroup], [UserGroup].[Name] AS [NameGroup], [UserGroup].[Default] AS [DefGroup], [User].[Id] AS [IdUser], [User].[Name] AS [NameUser], [User].[DNSName] AS [DNSName], [User].[ConnectMode] AS [ConnectMode], [User].[NoNet] AS [NoNet], [User].[GUID] AS [UserGuid], [Network].[IP] AS [NetIP], [Network].[Mask] AS [NetMask], [User].[IP] AS [IP], [User].[Mac] AS [Mac] FROM ([Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork]) LEFT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) AS Query_Nettree" SQL_QUERY_NETLIST "( SELECT [Network].[Id] AS [IdNetwork], [Network].[Name] AS [NameNetwork], [UserGroup].[Id] AS [IdGroup], [UserGroup].[Name] AS [NameGroup], [UserGroup].[Default] AS [DefGroup], [User].[Id] AS [IdUser], [User].[Name] AS [NameUser], [User].[DNSName] AS [DNSName], [User].[ConnectMode] AS [ConnectMode], [User].[NoNet] AS [NoNet], [User].[GUID] AS [UserGuid], [Network].[IP] AS [NetIP], [Network].[Mask] AS [NetMask], [User].[IP] AS [IP], [User].[Mac] AS [Mac] FROM ([Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork]) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) AS Query_Netlist" SQL_QUERY_RIGHTSLIST "( SELECT [User].[Id], [User].[Name], [User].[IP], [User].[Host], [User].[GUID], [Rights].[IdApp] FROM [User] RIGHT JOIN [Rights] ON [User].[Id] = [Rights].[IdUser] ) AS Query_Rightslist" SQL_QUERY_LICENSESLIST "( SELECT [Licenses].[Id], [Licenses].[IdApp], [Licenses].[Licenses], [Licenses].[Company], [Licenses].[Application], Count([RightsList].[Id]) AS [Users] FROM [Licenses] LEFT JOIN (SELECT [User].[Id], [User].[Name], [User].[IP], [User].[Host], [User].[GUID], [Rights].[IdApp] FROM [User] RIGHT JOIN [Rights] ON [User].[Id] = [Rights].[IdUser]) AS [RightsList] ON [Licenses].[IdApp] = [RightsList].[IdApp] GROUP BY [Licenses].[Id], [Licenses].[IdApp], [Licenses].[Licenses], [Licenses].[Company], [Licenses].[Application] ) AS Query_Licenseslist" SQL_QUERY_APPLIST "( SELECT [WinSession].[IdUser], [WinSession].[UserName], [WinSession].[Start], [WinSession].[Exit], [AppSessionSum].[ForeTime], [AppSessionSum].[IdApp], [App].[Name], [App].[Alias] FROM [WinSession] LEFT JOIN ([App] RIGHT JOIN [AppSessionSum] ON [App].[Id] = [AppSessionSum].[IdApp]) ON [WinSession].[Id] = [AppSessionSum].[IdSession] ) AS Query_Applist" SQL_QUERY_USERSTAT "( SELECT [WinSession].[IdUser] AS [IdUser], [WinSession].[UserName] AS [UserName], Sum([WinSession].[TotalTime]) AS [TotalTime] FROM [WinSession] WHERE ((([WinSession].[Start])>=%s) AND (([WinSession].[Exit])<=%s)) GROUP BY [WinSession].[IdUser], [WinSession].[UserName] ) AS Query_Userstat" SQL_QUERY_APPSTAT "( SELECT [Q_AppStatSum].[IdUser] AS [IdUser], [Q_AppStatSum].[UserName] AS [UserName], [Q_AppStatSum].[Alias] AS [Name], Sum([Q_AppStatSum].[KeyCount]) AS [KeyCount], Sum([Q_AppStatSum].[ClickCount]) AS [ClickCount], Sum([Q_AppStatSum].[TotalTime]) AS [TotalTime], Sum([Q_AppStatSum].[ActiveTime]/1000) AS [ActiveTime], Sum([Q_AppStatSum].[ForeTime]/1000) AS [ForeTime], (Sum([Q_AppStatSum].[ActiveTime]/1000)/(Sum([Q_AppStatSum].[ForeTime]/1000)+0.00001))*100 AS [Activity] FROM ( SELECT [WinSession].[IdUser], [WinSession].[UserName], [WinSession].[Start], [WinSession].[Exit], [AppSessionSum].[KeyCount], [AppSessionSum].[ClickCount], [AppSessionSum].[TotalTime], [AppSessionSum].[ActiveTime], [AppSessionSum].[ForeTime], [AppSessionSum].[Activity], [AppSessionSum].[IdApp], [App].[Name], [App].[Alias] FROM [WinSession] LEFT JOIN ([App] RIGHT JOIN [AppSessionSum] ON [App].[Id] = [AppSessionSum].[IdApp]) ON [WinSession].[Id] = [AppSessionSum].[IdSession] ) AS [Q_AppStatSum] WHERE ((([Q_AppStatSum].[Start])>=%s) AND (([Q_AppStatSum].[Exit])<=%s)) GROUP BY [Q_AppStatSum].[IdUser], [Q_AppStatSum].[UserName], [Q_AppStatSum].[Alias] ) AS Query_Appstat" SQL_QUERY_APPSTATNOUSER "( SELECT [Q_AppStatSum].[IdUser] AS [IdUser], [Q_AppStatSum].[Alias] AS [Name], Sum([Q_AppStatSum].[KeyCount]) AS [KeyCount], Sum([Q_AppStatSum].[ClickCount]) AS [ClickCount], Sum([Q_AppStatSum].[TotalTime]) AS [TotalTime], Sum([Q_AppStatSum].[ActiveTime]/1000) AS [ActiveTime], Sum([Q_AppStatSum].[ForeTime]/1000) AS [ForeTime], (Sum([Q_AppStatSum].[ActiveTime]/1000)/(Sum([Q_AppStatSum].[ForeTime]/1000)+0.00001))*100 AS [Activity] FROM (SELECT [WinSession].[IdUser], [WinSession].[UserName], [WinSession].[Start], [WinSession].[Exit], [AppSessionSum].[KeyCount], [AppSessionSum].[ClickCount], [AppSessionSum].[TotalTime], [AppSessionSum].[ActiveTime], [AppSessionSum].[ForeTime], [AppSessionSum].[Activity], [AppSessionSum].[IdApp], [App].[Name], [App].[Alias] FROM [WinSession] LEFT JOIN ([App] RIGHT JOIN [AppSessionSum] ON [App].[Id] = [AppSessionSum].[IdApp]) ON [WinSession].[Id] = [AppSessionSum].[IdSession] ) AS [Q_AppStatSum] WHERE ((([Q_AppStatSum].[Start])>=%s) AND (([Q_AppStatSum].[Exit])<=%s)) GROUP BY [Q_AppStatSum].[IdUser], [Q_AppStatSum].[Alias] ) AS Query_Appstatnouser" SQL_QUERY_WINSTAT "( SELECT [WinSession].[IdUser] AS [IdUser], [WinSession].[UserName] AS [UserName], Sum([WinSession].[KeyCount]) AS [KeyCount], Sum([WinSession].[ClickCount]) AS [ClickCount], Sum([WinSession].[TotalTime]) AS [TotalTime], Sum(([WinSession].[TotalTime]*[WinSession].[Active])/100) AS [ActiveTime], ((Sum(([WinSession].[TotalTime]*[WinSession].[Active])/100)*100)/(Sum([WinSession].[TotalTime])+0.00001)) AS [Activity] FROM [WinSession] WHERE ((([WinSession].[Start])>=%s) AND (([WinSession].[Exit])<=%s)) GROUP BY [WinSession].[IdUser], [WinSession].[UserName] ) AS Query_Winstat" SQL_QUERY_APPSTATSUM "( SELECT [WinSession].[IdUser], [WinSession].[UserName], [WinSession].[Start], [WinSession].[Exit], [AppSessionSum].[KeyCount], [AppSessionSum].[ClickCount], [AppSessionSum].[TotalTime], [AppSessionSum].[ActiveTime], [AppSessionSum].[ForeTime], [AppSessionSum].[Activity], [AppSessionSum].[IdApp], [App].[Name], [App].[Alias] FROM [WinSession] LEFT JOIN ([App] RIGHT JOIN [AppSessionSum] ON [App].[Id] = [AppSessionSum].[IdApp]) ON [WinSession].[Id] = [AppSessionSum].[IdSession] ) AS Query_Appstatsum" SQL_QUERY_UNKNOWNAPPLIST "( SELECT [UnknownAppInfo].[Id], [UnknownAppInfo].[IdScan], [UnknownAppInfo].[IdApp], [UnknownAppInfo].[Path], [UnknownApp].[ExeName], [UnknownApp].[CompanyName], [UnknownApp].[FileDescription], [UnknownApp].[FileVersion], [UnknownApp].[InternalName], [UnknownApp].[LegalCopyright], [UnknownApp].[OriginalFilename], [UnknownApp].[PrivateBuild], [UnknownApp].[ProductName], [UnknownApp].[ProductVersion], [UnknownApp].[SpecialBuild], [UnknownApp].[FileSize], [UnknownApp].[NoVersion], [UnknownAppInfo].[NoPrint], [UnknownAppInfo].[Omit], [UnknownAppInfo].[Attr], [UnknownAppInfo].[IdIcon] FROM [UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp] ) AS Query_Unknownapplist" SQL_QUERY_APPSESSIONLIST "( SELECT [AppSession].[IdSession] AS [IdSession], [WinSession].[IdUser] AS [IdUser], [WinSession].[Start] AS [WinStart], [WinSession].[Exit] AS [WinExit], [WinSession].[UserName] AS [UserName], [AppSession].[Id] AS [Id], [AppSession].[Start] AS [Start], [AppSession].[Exit] AS [Exit], [AppSession].[StartTick] AS [StartTick], [AppSession].[IdProcess] AS [IdProcess], [AppSession].[TotalTime] AS [TotalTime], [AppSession].[ActiveTime] AS [ActiveTime], [AppSession].[DeadTime] AS [DeadTime], [AppSession].[Activity] AS [Activity], [AppSession].[KeyCount] AS [KeyCount], [AppSession].[ClickCount] AS [ClickCount], [AppSession].[IdApp] AS [IdApp], [App].[Alias] AS [Name] FROM [WinSession] LEFT JOIN ([App] RIGHT JOIN [AppSession] ON [App].[Id] = [AppSession].[IdApp]) ON [WinSession].[Id] = [AppSession].[IdSession] ) AS Query_Appsessionlist" SQL_QUERY_SCANINFO_KNOWN "( SELECT [ScanAppInfo].[Id], [ScanAppInfo].[IdScan], [ScanAppInfo].[IdApp], [ScanAppInfo].[AppPath], [ScanAppInfo].[NoPrint], [ScanAppInfo].[Omit], [ScanAppInfo].[Attr], [ScanAppInfo].[IdPacket], [ScanAppInfo].[IdIcon], [KnownApp].[Company] AS [AppCompany], [KnownApp].[Name] AS [AppName], [KnownApp].[Version] AS [AppVersion], [KnownApp].[ExeName], [ScanRegInfo].[Name] AS [PacketName], [ScanRegInfo].[Version] AS [PacketVersion], [ScanRegInfo].[ProductID], [ScanRegInfo].[Publisher], [ScanRegInfo].[InstallDate] FROM ([ScanAppInfo] LEFT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id]) LEFT JOIN [ScanRegInfo] ON [ScanAppInfo].[IdPacket] = [ScanRegInfo].[Id] ) AS Query_Scaninfo_Known" SQL_QUERY_SCANINFO_UNKNOWN "( SELECT [UnknownAppInfo].[Id], [UnknownAppInfo].[IdScan], [UnknownAppInfo].[IdApp], [UnknownAppInfo].[Path], [UnknownAppInfo].[NoPrint], [UnknownAppInfo].[Omit], [UnknownAppInfo].[Attr], [UnknownAppInfo].[IdPacket], [UnknownAppInfo].[IdIcon], [UnknownApp].[ExeName], [UnknownApp].[CompanyName], [UnknownApp].[FileDescription], [UnknownApp].[FileVersion], [UnknownApp].[InternalName], [UnknownApp].[LegalCopyright], [UnknownApp].[OriginalFilename], [UnknownApp].[PrivateBuild], [UnknownApp].[ProductName], [UnknownApp].[ProductVersion], [UnknownApp].[SpecialBuild], [UnknownApp].[FileSize], [UnknownApp].[NoVersion], [ScanRegInfo].[Name], [ScanRegInfo].[Version], [ScanRegInfo].[ProductID], [ScanRegInfo].[Publisher], [ScanRegInfo].[InstallDate] FROM ([UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp]) LEFT JOIN [ScanRegInfo] ON [UnknownAppInfo].[IdPacket] = [ScanRegInfo].[Id] ) AS Query_Scaninfo_Unknown" SQL_QUERY_SCANINFO_REG "( SELECT [ScanRegInfo].[Id], [ScanRegInfo].[IdScan], [ScanRegInfo].[NoPrint], [ScanRegInfo].[Name], [ScanRegInfo].[Version], [ScanRegInfo].[ProductID], [ScanRegInfo].[Publisher], [ScanRegInfo].[InstallDate], [ScanRegComponent].[Path] FROM [ScanRegInfo] LEFT JOIN [ScanRegComponent] ON [ScanRegInfo].[Id] = [ScanRegComponent].[IdReg] ) AS Query_Scaninfo_Reg" SQL_QUERY_SCANINFO "( SELECT [Network].[Name] AS [NameNet], [UserGroup].[Name] AS [NameGroup], [UserGroup].[Default], [User].[Id] AS [IdUser], [User].[Name] AS [NameUser], [User].[IP], [User].[Host], [User].[GUID], [User].[AgentVersion], [ScanResult].[Id] AS [IdScan], [ScanResult].[Date], [ScanResult].[Mode], [ScanResult].[Hardware], [ScanResult].[Desc], [ScanResult].[Label1], [ScanResult].[Label2], [ScanResult].[Label3], [ScanResult].[Label4], [ScanResult].[Label5], [ScanResult].[Extra1], [ScanResult].[Extra2], [ScanResult].[Extra3], [ScanResult].[Extra4], [ScanResult].[Extra5] FROM (([Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork]) LEFT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup]) LEFT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) AS Query_Scaninfo" SQL_QUERY_SCANINFO_SIMPLE "( SELECT [Network].[Name] AS [NameNet], [UserGroup].[Name] AS [NameGroup], [UserGroup].[Default], [User].[Id] AS [IdUser], [User].[Name] AS [NameUser], [User].[IP], [User].[Host], [User].[GUID], [User].[AgentVersion], [ScanResult].[Id] AS [IdScan], [ScanResult].[Date], [ScanResult].[Mode], [ScanResult].[Desc], [ScanResult].[Label1], [ScanResult].[Label2], [ScanResult].[Label3], [ScanResult].[Label4], [ScanResult].[Label5], [ScanResult].[Extra1], [ScanResult].[Extra2], [ScanResult].[Extra3], [ScanResult].[Extra4], [ScanResult].[Extra5] FROM (([Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork]) LEFT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup]) LEFT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) AS Query_Scaninfo" SQL_QUERY_WEBHISTORY "( SELECT [WebSession].[Id] AS [Id], [WebSession].[IdUser] AS [IdUser], [WebSession].[UserName] AS [UserName], [WebTime].[Id] AS [IdTime], [WebTime].[Start] AS [Start], [WebTime].[WorkTime] AS [WorkTime], [WebSite].[Id] AS [IdSite], [WebSite].[Title] AS [Title], [WebSite].[URL] AS [URL] FROM [WebSession] INNER JOIN ([WebTime] LEFT JOIN [WebSite] ON [WebTime].[IdSite] = [WebSite].[Id]) ON [WebSession].[Id] = [WebTime].[IdSession] ) AS Query_Webhistory" SQL_QUERY_WEBSUMMARY "( SELECT [SubSum].[IdUser], [SubSum].[IdSite], [SubSum].[UserName], Sum([SubSum].[TotalWorkTime]) AS [TotalTime], [SubSum].[URL], [SubSum].[Title] FROM (SELECT [WebSession].[Id], [WebSession].[IdUser], [WebSession].[UserName], [WebTime].[IdSite], [WebTime].[Start], Sum([WebTime].[WorkTime]) AS [TotalWorkTime], [WebSite].[URL], [WebSite].[Title] FROM [WebSession] LEFT JOIN ([WebTime] LEFT JOIN [WebSite] ON [WebTime].[IdSite] = [WebSite].[Id]) ON [WebSession].[Id] = [WebTime].[IdSession] GROUP BY [WebSession].[Id], [WebSession].[IdUser], [WebSession].[UserName], [WebTime].[IdSite], [WebTime].[Start], [WebSite].[URL], [WebSite].[Title] HAVING ( (([WebTime].[Start])>=%s AND ([WebTime].[Start])<=%s))) AS [SubSum] GROUP BY [SubSum].[IdUser], [SubSum].[IdSite], [SubSum].[UserName], [SubSum].[URL], [SubSum].[Title] ) AS Query_Websummary" SQL_READ_AUDIT_ID "SELECT [Id] FROM [ScanResult] WHERE [IdUser] IN (%s) AND CAST([IdUser] AS VARCHAR)+'-'+CAST([Date] AS VARCHAR) IN ( SELECT CAST([IdUser] AS VARCHAR)+'-'+CAST(Max([Date]) AS VARCHAR) FROM [ScanResult] GROUP BY [IdUser] )" SQL_UNKNOWN_COMPANY_QUERY "SELECT [CompanyName], Min([Id]) AS [FirstId] FROM [UnknownApp] GROUP BY [CompanyName] ORDER BY [CompanyName]" SQL_UNKNOWN_COMPANY_QUERY_IN "SELECT [CompanyName], Min([Id]) AS [FirstId] FROM [UnknownApp] WHERE [Id] IN (%s) GROUP BY [CompanyName] ORDER BY [CompanyName]" SQL_SELECT_ID_FROM_UNKNOWNAPP "SELECT [Id] FROM [UnknownApp]" SQL_GET_COMPANY_LIST_KNOWN "SELECT Min(CAST(NoPrint AS INTEGER)) AS p1, Max(CAST(NoPrint AS INTEGER)) AS p2, AppCompany FROM ( SELECT [ScanAppInfo].[IdScan], [ScanAppInfo].[NoPrint], [ScanAppInfo].[Omit], [KnownApp].[Company] AS [AppCompany] FROM ([ScanAppInfo] LEFT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id] ) WHERE [Omit] = %s AND [IdScan] IN (%s) ) AS SubQuery GROUP BY AppCompany ORDER BY AppCompany" SQL_GET_COMPANY_LIST_UNKNOWN "SELECT Min(CAST(NoPrint AS INTEGER)) AS p1, Max(CAST(NoPrint AS INTEGER)) AS p2, AppCompany, NoVersion FROM ( SELECT [UnknownAppInfo].[IdScan], [UnknownAppInfo].[NoPrint], [UnknownAppInfo].[Omit], [UnknownApp].[CompanyName] AS AppCompany, [UnknownApp].[NoVersion] FROM ([UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp]) WHERE [Omit] = %s AND [IdScan] IN (%s) ) AS SubQuery GROUP BY AppCompany, NoVersion ORDER BY AppCompany, NoVersion DESC" SQL_MULTI_APP_BY_COMPANY_KNOWN "SELECT Min([Id]) AS [Id], [IdApp], [NoPrint], Min([IdIcon]) AS [MinIdIcon], [AppCompany], [AppName], [AppVersion] FROM ( SELECT [ScanAppInfo].[Id], [ScanAppInfo].[IdScan], [ScanAppInfo].[IdApp], [ScanAppInfo].[NoPrint], [ScanAppInfo].[Omit], [ScanAppInfo].[IdIcon], [KnownApp].[Company] AS [AppCompany], [KnownApp].[Name] AS [AppName], [KnownApp].[Version] AS [AppVersion] FROM ([ScanAppInfo] LEFT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id]) WHERE [Company] = '%s' AND [Omit] = %s AND [IdScan] IN (%s) ) AS SubQuery GROUP BY [IdApp], [NoPrint], [AppCompany], [AppName], [AppVersion] ORDER BY %s" SQL_MULTI_APP_BY_COMPANY_UNKNOWN "SELECT Min([Id]) AS [Id], [IdApp], [NoPrint], Min([IdIcon]) AS [MinIdIcon], [ExeName], [AppCompany], [AppDesc], [AppVersion], [NoVersion] FROM ( SELECT [UnknownAppInfo].[Id], [UnknownAppInfo].[IdScan], [UnknownAppInfo].[IdApp], [UnknownAppInfo].[NoPrint], [UnknownAppInfo].[Omit], [UnknownAppInfo].[IdIcon], [UnknownApp].[ExeName], [UnknownApp].[CompanyName] AS [AppCompany], [UnknownApp].[FileDescription] AS [AppDesc], [UnknownApp].[FileVersion] AS [AppVersion], [UnknownApp].[NoVersion] FROM ([UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp]) WHERE [CompanyName] = '%s' AND [Omit] = %s AND [NoVersion] = %s AND [IdScan] IN (%s) ) AS SubQuery GROUP BY [IdApp], [NoPrint], [ExeName], [AppCompany], [AppDesc], [AppVersion], [NoVersion] ORDER BY %s" SQL_TEST_COMPANY_PRINT_KNOWN "SELECT TOP 1 [NoPrint] FROM ( [KnownApp] RIGHT JOIN [ScanAppInfo] ON [KnownApp].[Id] = [ScanAppInfo].[IdApp] ) WHERE [Company] = '%s' AND [Omit] = %s AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_TEST_COMPANY_PRINT_UNKNOWN "SELECT TOP 1 [NoPrint] FROM ( [UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp] ) WHERE [CompanyName] = '%s' AND [Omit] = %s AND [NoVersion] = %s AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_MULTI_APP_FROM_REG "SELECT Min([Id]) AS [Id], [NoPrint], [Name], [Version] FROM [ScanRegInfo] WHERE [IdScan] IN (%s) GROUP BY [NoPrint], [Name], [Version] ORDER BY %s" SQL_AUDIT_SUMMARY_KNOWN "SELECT [AppCount], [Computers], [IdInfo], [IdApp], [Company], [Name], [Version], [MinIdIcon] FROM ( SELECT Sum([AppCount]) AS [AppCount], Count(*) AS [Computers], Min([IdInfo]) AS [IdInfo], [IdApp], Min([MinIdIcon]) AS [MinIdIcon] FROM ( SELECT Count(*) AS [AppCount], Min([Id]) AS [IdInfo], [IdApp], Min ([IdIcon]) AS [MinIdIcon] FROM [ScanAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdScan], [IdApp] ) AS SubQuery GROUP BY [IdApp] ) AS MainQuery LEFT JOIN [KnownApp] ON [MainQuery].[IdApp] = [KnownApp].[Id] ORDER BY [Company], [Name], [Version]" SQL_AUDIT_SUMMARY_KNOWN_BY_USER "SELECT Count(*) AS [AppCount], Min([ScanAppInfo].[Id]) AS [IdInfo], [ScanAppInfo].[IdApp] AS [IdApp], [User].[Id] AS [IdUser], [User].[Name] AS [UserName], [KnownApp].[Company], [KnownApp].[Name], [KnownApp].[Version], Min([ScanAppInfo].[IdIcon]) AS [MinIdIcon] FROM ( ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [ScanAppInfo] ON [ScanResult].[Id] = [ScanAppInfo].[IdScan] ) RIGHT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id] WHERE [NoPrint] = 0 AND [Omit] = %s AND [ScanResult].[Id] IN (%s) GROUP BY [ScanAppInfo].[IdApp], [User].[Id], [User].[Name], [KnownApp].[Company], [KnownApp].[Name], [KnownApp].[Version] ORDER BY [User].[Name], [KnownApp].[Company], [KnownApp].[Name], [KnownApp].[Version]" SQL_AUDIT_SUMMARY_UNKNOWN "SELECT [AppCount], [Computers], [IdInfo], [IdApp], [NoVersion], [CompanyName], [FileDescription], [FileVersion], [ExeName], [MinIdIcon] FROM ( SELECT Sum([AppCount]) AS [AppCount], Count(*) AS [Computers], Min([IdInfo]) AS [IdInfo], [IdApp], Min([MinIdIcon]) AS [MinIdIcon] FROM ( SELECT Count(*) AS [AppCount], Min([Id]) AS [IdInfo], [IdApp], Min([IdIcon]) AS [MinIdIcon] FROM [UnknownAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdScan], [IdApp] ) AS SubQuery GROUP BY [IdApp] ) AS MainQuery LEFT JOIN [UnknownApp] ON [MainQuery].[IdApp] = [UnknownApp].[Id] ORDER BY [NoVersion] DESC, [CompanyName], [FileDescription], [ExeName], [FileVersion]" SQL_AUDIT_SUMMARY_UNKNOWN_BY_USER "SELECT Count(*) AS [AppCount], Min([UnknownAppInfo].[Id]) AS [IdInfo], [UnknownAppInfo].[IdApp] AS [IdApp], [User].[Id] AS [IdUser], [User].[Name] AS [UserName], [UnknownApp].[NoVersion], [UnknownApp].[CompanyName], [UnknownApp].[FileDescription], [UnknownApp].[ExeName], [UnknownApp].[FileVersion], Min([UnknownAppInfo].[IdIcon]) AS [MinIdIcon] FROM ( ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [UnknownAppInfo] ON [ScanResult].[Id] = [UnknownAppInfo].[IdScan] ) RIGHT JOIN [UnknownApp] ON [UnknownAppInfo].[IdApp] = [UnknownApp].[Id] WHERE [NoPrint] = 0 AND [Omit] = %s AND [ScanResult].[Id] IN (%s) GROUP BY [UnknownAppInfo].[IdApp], [User].[Id], [User].[Name], [UnknownApp].[NoVersion], [UnknownApp].[CompanyName], [UnknownApp].[FileDescription], [UnknownApp].[ExeName], [UnknownApp].[FileVersion] ORDER BY [User].[Name], [NoVersion] DESC, [CompanyName], [FileDescription], [ExeName], [FileVersion]" SQL_AUDIT_SUMMARY_REGISTRY "SELECT Min([Id]) AS [IdInfo], Sum([SubTotal]) AS [AppCount], Count(*) AS [Computers], [Name], [Version] FROM ( SELECT Count(*) AS [SubTotal], Min([Id]) AS [Id], [IdScan], [Name], [Version] FROM [ScanRegInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) GROUP BY [IdScan], [Name], [Version] ) AS [SubQuery] GROUP BY [Name], [Version] ORDER BY [Name], [Version]" SQL_AUDIT_SUMMARY_REGISTRY_BY_USER "SELECT Count(*) AS [AppCount], [User].[Id] AS [IdUser], [User].[Name] AS [UserName], [ScanRegInfo].[Name], [ScanRegInfo].[Version] FROM ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [ScanRegInfo] ON [ScanResult].[Id] = [ScanRegInfo].[IdScan] WHERE [ScanRegInfo].[NoPrint] = 0 AND [ScanResult].[Id] IN (%s) GROUP BY [User].[Id], [User].[Name], [ScanRegInfo].[Name], [ScanRegInfo].[Version] ORDER BY [User].[Name], [ScanRegInfo].[Name], [ScanRegInfo].[Version]" SQL_AUDIT_SUMMARY_SYSTEM "SELECT Sum([AppCount]) AS [AppCount], Count(*) AS [Computers], Min([IdInfo]) AS [IdInfo], [Name] FROM ( SELECT Count(*) AS [AppCount], Min([Id]) AS [IdInfo], [Name], [Version] FROM [ScanSystemInfo] WHERE [IdScan] IN (%s) GROUP BY [IdScan], [Name], [Version] ) AS SubQuery GROUP BY [Name], [Version] ORDER BY [Version], [Name]" SQL_AUDIT_SUMMARY_SYSTEM_BY_USER "SELECT Count(*) AS [AppCount], [User].[Id] AS [IdUser], [User].[Name] AS [UserName], [ScanSystemInfo].[Name] FROM ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [ScanSystemInfo] ON [ScanResult].[Id] = [ScanSystemInfo].[IdScan] WHERE [ScanResult].[Id] IN (%s) GROUP BY [User].[Id], [User].[Name], [ScanSystemInfo].[Name], [ScanSystemInfo].[Version] ORDER BY [User].[Name], [ScanSystemInfo].[Version], [ScanSystemInfo].[Name]" SQL_AUDIT_SUMMARY_APPUSERS_KNOWN "SELECT Count(*) AS [AppCount], [User].[Name] FROM [User] RIGHT JOIN ([ScanResult] RIGHT JOIN [ScanAppInfo] ON [ScanResult].[Id] =[ScanAppInfo].[IdScan]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) AND [IdApp] = %d GROUP BY [Name] ORDER BY [Name]" SQL_AUDIT_SUMMARY_APPUSERS_UNKNOWN "SELECT Count(*) AS [AppCount], [User].[Name] FROM [User] RIGHT JOIN ([ScanResult] RIGHT JOIN [UnknownAppInfo] ON [ScanResult].[Id] =[UnknownAppInfo].[IdScan]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) AND [IdApp] = %d GROUP BY [Name] ORDER BY [Name]" SQL_AUDIT_SUMMARY_REGUSERS "SELECT Count(*) AS [AppCount], [User].[Name] FROM ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) LEFT JOIN [ScanRegInfo] ON [ScanResult].[Id] = [ScanRegInfo].[IdScan] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) AND [ScanRegInfo].[Name] %s AND [ScanRegInfo].[Version] %s GROUP BY [User].[Name] ORDER BY [User].[Name]" SQL_AUDIT_SUMMARY_SYSUSERS "SELECT Count(*) AS [AppCount], [User].[Name] FROM ( [User] RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) LEFT JOIN [ScanSystemInfo] ON [ScanResult].[Id] = [ScanSystemInfo].[IdScan] WHERE [IdScan] IN (%s) AND [ScanSystemInfo].[Name] = '%s' GROUP BY [User].[Name] ORDER BY [User].[Name]" SQL_AUDIT_SUMMARY_USERS "SELECT [Network].[Name] AS [NetworkName], [UserGroup].[Name] AS [GroupName], [UserGroup].[Default] AS [DefGroup], [User].[Name] AS [UserName], [User].[IP], [User].[Host], [User].[GUID], [ScanResult].[Id] AS [IdScan], [ScanResult].[Date] AS [AuditDate], [ScanResult].[Desc] AS [AuditDesc], [ScanResult].[Label1], [ScanResult].[Label2], [ScanResult].[Label3], [ScanResult].[Label4], [ScanResult].[Label5], [ScanResult].[Extra1], [ScanResult].[Extra2], [ScanResult].[Extra3], [ScanResult].[Extra4], [ScanResult].[Extra5] FROM ( ( [Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] WHERE [ScanResult].[Id] IN (%s) ORDER BY [User].[Name], [User].[IP]" SQL_AUDIT_SUMMARY_COUNT_KNOWN "SELECT Count(*) AS [RecordCount] FROM [ScanAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s)" SQL_AUDIT_SUMMARY_COUNT_UNKNOWN "SELECT Count(*) AS [RecordCount] FROM [UnknownAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s)" SQL_AUDIT_SUMMARY_COUNT_REGISTRY "SELECT Count(*) AS [RecordCount] FROM [ScanRegInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s)" SQL_AUDIT_SUMMARY_COUNT_SYSTEM "SELECT Count(*) AS [RecordCount] FROM [ScanSystemInfo] WHERE [IdScan] IN (%s)" SQL_AUDIT_SUMMARY_COUNT_FILES "SELECT Count(*) AS [RecordCount] FROM [ScanFileInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) AND [IdGroup] IN (%s)" SQL_AUDIT_SUMMARY_COUNT_KNOWN_BY_AUDIT "SELECT Count(*) AS [RecordCount], [IdScan] FROM [ScanAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdScan]" SQL_AUDIT_SUMMARY_COUNT_UNKNOWN_BY_AUDIT "SELECT Count(*) AS [RecordCount], [IdScan] FROM [UnknownAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdScan]" SQL_AUDIT_SUMMARY_COUNT_REGISTRY_BY_AUDIT "SELECT Count(*) AS [RecordCount], [IdScan] FROM [ScanRegInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) GROUP BY [IdScan]" SQL_AUDIT_SUMMARY_COUNT_SYSTEM_BY_AUDIT "SELECT Count(*) AS [RecordCount], [IdScan] FROM [ScanSystemInfo] WHERE [IdScan] IN (%s) GROUP BY [IdScan]" SQL_AUDIT_SUMMARY_COUNT_FILES_BY_AUDIT "SELECT Count(*) AS [RecordCount], [IdScan] FROM [ScanFileInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) AND [IdGroup] IN (%s) GROUP BY [IdScan]" SQL_AUDIT_SUMMARY_SAVE_KNOWN "SELECT [ScanResult].[Date] AS [AuditDate], [User].[Name] AS [UserName], [User].[IP] AS [UserIP], [User].[Host], [User].[GUID], [KnownApp].[Company] AS [AppCompany], [KnownApp].[Name] AS [AppName], [KnownApp].[Version] AS [AppVersion], [ScanRegInfo].[Name] AS [Packet], [ScanAppInfo].[AppPath] FROM [User] RIGHT JOIN ( [ScanResult] RIGHT JOIN (([ScanAppInfo] LEFT JOIN [ScanRegInfo] ON [ScanAppInfo].[IdPacket] = [ScanRegInfo].[Id]) LEFT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id]) ON [ScanResult].[Id] = [ScanAppInfo].[IdScan]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [ScanAppInfo].[NoPrint] = 0 AND [ScanAppInfo].[Omit] = %s AND [ScanResult].[Id] IN (%s) ORDER BY [User].[Name], [User].[IP], [KnownApp].[Company], [KnownApp].[Name], [KnownApp].[Version]" SQL_AUDIT_SUMMARY_SAVE_UNKNOWN "SELECT [ScanResult].[Date] AS [AuditDate], [User].[Name] AS [UserName], [User].[IP] AS [UserIP], [User].[Host], [User].[GUID], [UnknownApp].[CompanyName] AS [AppCompany], [UnknownApp].[FileDescription] AS [AppName], [UnknownApp].[FileVersion] AS [AppVersion], [UnknownApp].[ExeName], [UnknownApp].[NoVersion], [ScanRegInfo].[Name] AS [Packet], [UnknownAppInfo].[Path] AS [AppPath] FROM [User] RIGHT JOIN ( [ScanResult] RIGHT JOIN (([UnknownAppInfo] LEFT JOIN [ScanRegInfo] ON [UnknownAppInfo].[IdPacket] = [ScanRegInfo].[Id]) LEFT JOIN [UnknownApp] ON [UnknownAppInfo].[IdApp] = [UnknownApp].[Id]) ON [ScanResult].[Id] = [UnknownAppInfo].[IdScan]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [UnknownAppInfo].[NoPrint] = 0 AND [UnknownAppInfo].[Omit] = %s AND [ScanResult].[Id] IN (%s) ORDER BY [User].[Name], [User].[IP], [UnknownApp].[NoVersion], [UnknownApp].[CompanyName], [UnknownApp].[FileDescription], [UnknownApp].[ExeName], [UnknownApp].[FileVersion]" SQL_AUDIT_SUMMARY_SAVE_REGISTRY "SELECT [ScanResult].[Date] AS [AuditDate], [User].[Name] AS [UserName], [User].[IP] AS [UserIP], [User].[Host], [User].[GUID], [ScanRegInfo].[Name] AS [AppName], [ScanRegInfo].[Version] AS [AppVersion], [ScanRegInfo].[ProductID], [ScanRegInfo].[Publisher], [ScanRegInfo].[InstallDate] FROM [User] RIGHT JOIN ([ScanRegInfo] LEFT JOIN [ScanResult] ON [ScanRegInfo].[IdScan] = [ScanResult].[Id]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [ScanRegInfo].[NoPrint] = 0 AND [ScanResult].[Id] IN (%s) ORDER BY [User].[Name], [User].[IP], [ScanRegInfo].[Name], [ScanRegInfo].[Version], [ScanRegInfo].[ProductID]" SQL_AUDIT_SUMMARY_SAVE_SYSTEM "SELECT [ScanResult].[Date] AS [AuditDate], [User].[Name] AS [UserName], [User].[IP] AS [UserIP], [User].[Host], [User].[GUID], [ScanSystemInfo].[Name] AS [AppName], [ScanSystemInfo].[Version] AS [AppVersion], [ScanSystemInfo].[Compilation], [ScanSystemInfo].[IdProduct], [ScanSystemInfo].[ProductKey] FROM [User] RIGHT JOIN ([ScanSystemInfo] LEFT JOIN [ScanResult] ON [ScanSystemInfo].[IdScan] = [ScanResult].[Id]) ON [User].[Id] = [ScanResult].[IdUser] WHERE [ScanResult].[Id] IN (%s) ORDER BY [User].[Name], [User].[IP], [ScanSystemInfo].[Version], [ScanSystemInfo].[Name], [ScanSystemInfo].[Compilation]" SQL_GET_UNKNOWNAPP_BY_MD5 "SELECT [Id] FROM [UnknownApp] WHERE [MD5] = '%s'" SQL_GET_USER_BY_GUID "SELECT * FROM [User] WHERE [GUID] = '%s'" SQL_GET_AUDIT_BY_USER_AND_DATE "SELECT * FROM [ScanResult] WHERE [IdUser] = %d AND [Date] = %s" SQL_GET_USERS_BY_NETWORK "SELECT [Network].[Id] AS [IdNetwork], [User].[Id] AS [IdUser], [Network].[Name] AS [NetworkName], [User].[Name] AS [UserName] FROM ( [Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] WHERE [Network].[Id] IN (%s)" SQL_GET_USERS_BY_GROUP "SELECT [UserGroup].[Id] AS [IdGroup], [User].[Id] AS [IdUser], [UserGroup].[Name] AS [GroupName], [UserGroup].[Default] AS [DefaultGroup], [User].[Name] AS [UserName] FROM [UserGroup] RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] WHERE [UserGroup].[Id] IN (%s)" SQL_FPUPDATE_KNOWN "SELECT [IdApp], [Omit] FROM [ScanAppInfo] GROUP BY [IdApp], [Omit]" SQL_FPUPDATE_COUNT_KNOWN "SELECT Count(*) AS [RecordCount] FROM ( SELECT [IdApp], [Omit] FROM [ScanAppInfo] GROUP BY [IdApp], [Omit] ) AS SubQuery" SQL_HARDWARE_SUMMARY "SELECT [Network].[Id] AS [NetworkID], [Network].[Name] AS [NetworkName], [UserGroup].[Id] AS [UserGroupID], [UserGroup].[Name] AS [UserGroupName], [UserGroup].[Default] AS [UserGroupDefault], [User].[Id] AS [UserID], [User].[Name] AS [UserName], [User].[NoNet] AS [UserNoNet], [User].[IP] AS [UserIP], [User].[Hardware] AS [UserHardware] FROM ( [Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) LEFT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] WHERE [User].[Id] IN (%s) ORDER BY [User].[Name]" SQL_TOTAL_AUDIT_INFO "SELECT Count(*) AS [RecordCount], Min([Date]) AS [DateMin], Max([Date]) AS [DateMax] FROM [ScanResult] WHERE [IdUser] IN (%s)" SQL_TOTAL_STATLOOK_INFO "SELECT Count(*) AS [RecordCount], Min([Start]) AS [DateMin], Max([Exit]) AS [DateMax] FROM [WinSession] WHERE [IdUser] IN (%s)" SQL_TOTAL_WEBLOOK_INFO "SELECT Count(*) AS [RecordCount], Min([Start]) AS [DateMin], Max([Start]) AS [DateMax] FROM [WebSession] WHERE [IdUser] IN (%s)" SQL_GET_ALL_USER_ID "SELECT [User].[Id] AS [IdUser] FROM [User]" SQL_GET_AUDIT_YEARMONTH "SELECT DISTINCT Year([Date]) * 100 + Month([Date]) AS [ItemDate] FROM [ScanResult] WHERE [IdUser] IN (%s)" SQL_GET_STATLOOK_YEARMONTH "SELECT DISTINCT Year([Start]) * 100 + Month([Start]) AS [ItemDate] FROM [WinSession] WHERE [IdUser] IN (%s)" SQL_GET_WEBLOOK_YEARMONTH "SELECT DISTINCT Year([Start]) * 100 + Month([Start]) AS [ItemDate] FROM [WebSession] WHERE [IdUser] IN (%s)" SQL_AUDIT_SUMMARYDIFF_USERS "SELECT [Network].[Name] AS [NetworkName], [UserGroup].[Name] AS [UserGroupName], [User].[Id] AS [UserID], [User].[Name] AS [UserName], [User].[IP] AS [UserIP], [User].[Host] AS [UserHost], [User].[GUID] AS [UserGUID] FROM ( [Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) LEFT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] WHERE [User].[Id] IN (%s) ORDER BY [User].[Name]" SQL_AUDIT_SUMMARYDIFF_DATES "SELECT [ScanResult].[Id] AS [ScanResultID], [ScanResult].[IdUser] AS [ScanResultUserID], [ScanResult].[Date] AS [ScanResultDate] FROM [ScanResult] WHERE [ScanResult].[IdUser] IN ( %s ) ORDER BY [ScanResult].[Date]" SQL_AUDIT_SUMMARYDIFF_KNOWN "SELECT [ScanResult].[Id] AS [ScanResultID], [ScanResult].[IdUser] AS [ScanResultUserID], [ScanAppInfo].[Id] AS [ScanAppID], [ScanAppInfo].[IdIcon] AS [AppIconID], [KnownApp].[Id] AS [AppID], [KnownApp].[Company] AS [AppCompany], [KnownApp].[Name] AS [AppName], [KnownApp].[Version] AS [AppVersion] FROM ([ScanResult] LEFT JOIN ([ScanAppInfo] LEFT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id]) ON [ScanResult].[Id] = [ScanAppInfo].[IdScan]) WHERE [ScanResult].[Id] IN (%s) AND [ScanAppInfo].[NoPrint] = %s AND [ScanAppInfo].[Omit] = %s" SQL_AUDIT_SUMMARYDIFF_UNKNOWN "SELECT [ScanResult].[Id] AS [ScanResultID], [ScanResult].[IdUser] AS [ScanResultUserID], [UnknownAppInfo].[Id] AS [ScanAppID], [UnknownAppInfo].[IdIcon] AS [AppIconID], [UnknownApp].[Id] AS [AppID], [UnknownApp].[CompanyName] AS [AppCompany], [UnknownApp].[ExeName] AS [AppName], [UnknownApp].[FileDescription] AS [AppDescription], [UnknownApp].[FileVersion] AS [AppVersion], [UnknownApp].[NoVersion] AS [AppNoVersion] FROM ([ScanResult] LEFT JOIN ([UnknownAppInfo] LEFT JOIN [UnknownApp] ON [UnknownAppInfo].[IdApp] = [UnknownApp].[Id]) ON [ScanResult].[Id] = [UnknownAppInfo].[IdScan]) WHERE [ScanResult].[Id] IN (%s) AND [UnknownAppInfo].[NoPrint] = %s AND [UnknownAppInfo].[Omit] = %s" SQL_AUDIT_SUMMARYDIFF_REGISTRY "SELECT [ScanResult].[Id] AS [ScanResultID], [ScanResult].[IdUser] AS [ScanResultUserID], [ScanRegInfo].[Publisher] AS [AppCompany], [ScanRegInfo].[Name] AS [AppName], [ScanRegInfo].[Version] AS [AppVersion] FROM ([ScanResult] LEFT JOIN [ScanRegInfo] ON [ScanResult].[Id] = [ScanRegInfo].[IdScan]) WHERE [ScanResult].[Id] IN (%s) AND [ScanRegInfo].[NoPrint] = %s" SQL_SEL_AC_GROUPAGENTCONFIG "SELECT [UserGroup].[IdNetwork] AS [NetworkID], [UserGroup].[AgentConfig] AS [GroupAgentConfig] FROM [UserGroup] WHERE [UserGroup].[Id]=%u" SQL_SEL_AC_NETWORKAGENTCONFIG "SELECT [Network].[AgentConfig] AS [NetworkAgentConfig] FROM [Network] WHERE [Network].[Id]=%u" SQL_SEL_NETWORKID_FROM_GROUPID "SELECT [UserGroup].[IdNetwork] AS [NetworkID] FROM [UserGroup] WHERE [UserGroup].[Id] = %u" SQL_SEL_GROUPHIERARCHY "SELECT [Network].[Name] AS [NetworkName], [UserGroup].[Default] AS [GroupDefault], [UserGroup].[Name] AS [GroupName], [UserGroup].[Id] AS [GroupID] FROM [Network] LEFT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ORDER BY [Network].[Name], [UserGroup].[Default], [UserGroup].[Name]" SQL_SEL_AUDITEDUSERID "SELECT [ScanResult].[IdUser] AS [UserID], max([ScanResult].[Date]) AS [Date] FROM [ScanResult] GROUP BY [ScanResult].[IdUser]" SQL_SEL_GROUPEDKNOWNAPPCOMPANY "SELECT [KnownApp].[Company] AS [KnownAppCompany] FROM [KnownApp] GROUP BY [KnownApp].[Company]" SQL_SEL_KNOWNAPP "SELECT [KnownApp].[Id] AS [KnownAppID], [KnownApp].[Company] AS [KnownAppCompany], [KnownApp].[Name] AS [KnownAppName], [KnownApp].[Version] AS [KnownAppVersion] FROM [KnownApp] %s%s" SQL_SEL_GROUPEDUNKNOWNAPPCOMPANY "SELECT [UnknownApp].[CompanyName] AS [UnknownAppCompanyName] FROM [UnknownApp] GROUP BY [UnknownApp].[CompanyName]" SQL_SEL_UNKNOWNAPP "SELECT [UnknownApp].[Id] AS [UnknownAppID], [UnknownApp].[CompanyName] AS [UnknownAppCompanyName], [UnknownApp].[FileDescription] AS [UnknownAppFileDescription], [UnknownApp].[FileVersion] AS [UnknownAppFileVersion], [UnknownApp].[ExeName] AS [UnknownAppExeName], [UnknownApp].[NoVersion] AS [UnknownAppNoVersion], [UnknownApp].[IdIcon] AS [UnknownAppIconID] FROM [UnknownApp] %s%s" SQL_SEL_USERS_WITHOUT_HARDWAREINFO "SELECT [User].[Id] AS [UserID] FROM [User] WHERE [User].[Hardware] IS NULL" SQL_SEL_LASTSCANRESULTID "SELECT [IdUser], [Id] FROM [ScanResult] WHERE CAST([IdUser] AS VARCHAR)+'-'+CAST([Date] AS VARCHAR) IN ( SELECT CAST([IdUser] AS VARCHAR)+'-'+CAST(Max([Date]) AS VARCHAR) FROM [ScanResult] GROUP BY [IdUser] )" SQL_SEL_FINAPP_KNOWNAPP "SELECT [Network].[Name] AS [NetworkName], [UserGroup].[Name] AS [GroupName], [UserGroup].[Default] AS [GroupDefault], [User].[Name] AS [UserName], Min([ScanAppInfo].[IdIcon]) AS [ApplicationIconIDMin], [ScanAppInfo].[Omit] AS [Omited], Count([ScanAppInfo].[IdApp]) AS [SetupCount], [KnownApp].[Company] AS [Company], [KnownApp].[Name] AS [Application], [KnownApp].[Version] AS [Version] FROM ( ( ( ( ( [Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [ScanAppInfo] ON [ScanResult].[Id] = [ScanAppInfo].[IdScan] ) RIGHT JOIN [KnownApp] ON [ScanAppInfo].[IdApp] = [KnownApp].[Id] ) WHERE [ScanResult].[Id] IN ( %s ) %sGROUP BY [Network].[Name], [UserGroup].[Name], [UserGroup].[Default], [User].[Name], [ScanAppInfo].[Omit], [KnownApp].[Company], [KnownApp].[Name], [KnownApp].[Version]" SQL_SEL_FINAPP_UNKNOWNAPP "SELECT [Network].[Name] AS [NetworkName], [UserGroup].[Name] AS [GroupName], [UserGroup].[Default] AS [GroupDefault], [User].[Name] AS [UserName], Min([UnknownAppInfo].[IdIcon]) AS [ApplicationIconIDMin], [UnknownAppInfo].[Omit] AS [Omited], Count([UnknownAppInfo].[IdApp]) AS [SetupCount], [UnknownApp].[CompanyName] AS [Company], [UnknownApp].[ExeName] AS [ExeName], [UnknownApp].[NoVersion] AS [NoVersion], [UnknownApp].[FileDescription] AS [Application], [UnknownApp].[FileVersion] AS [Version] FROM ( ( ( ( ( [Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [UnknownAppInfo] ON [ScanResult].[Id] = [UnknownAppInfo].[IdScan] ) RIGHT JOIN [UnknownApp] ON [UnknownAppInfo].[IdApp] = [UnknownApp].[Id] ) WHERE [ScanResult].[Id] IN ( %s ) %sGROUP BY [Network].[Name], [UserGroup].[Name], [UserGroup].[Default], [User].[Name], [UnknownAppInfo].[Omit], [UnknownApp].[CompanyName], [UnknownApp].[ExeName], [UnknownApp].[NoVersion], [UnknownApp].[FileDescription], [UnknownApp].[FileVersion]" SQL_SEL_FINAPP_REGISTRYAPP "SELECT [ScanRegInfo].[Publisher] AS [Company], [ScanRegInfo].[Name] AS [Application], [ScanRegInfo].[Version] AS [Version], [Network].[Name] AS [NetworkName], [UserGroup].[Name] AS [GroupName], [UserGroup].[Default] AS [GroupDefault], [User].[Name] AS [UserName] FROM ( ( ( [Network] RIGHT JOIN [UserGroup] ON [Network].[Id] = [UserGroup].[IdNetwork] ) RIGHT JOIN [User] ON [UserGroup].[Id] = [User].[IdGroup] ) RIGHT JOIN [ScanResult] ON [User].[Id] = [ScanResult].[IdUser] ) RIGHT JOIN [ScanRegInfo] ON [ScanResult].[Id] = [ScanRegInfo].[IdScan] WHERE [ScanResult].[Id] IN ( %s ) %s%s" SQL_SEL_IMAGELIST "SELECT * FROM [ImageList]" SQL_SEL_SCANAPPINFO_IMAGEINFO "SELECT [ScanResult].[IdImageList] AS [ScanResultImageListID], [ScanAppInfo].[Image] AS [ScanAppInfoImage], [ScanAppInfo].[IdIcon] AS [ScanAppInfoIdIcon] FROM [ScanResult] RIGHT JOIN [ScanAppInfo] ON [ScanAppInfo].[IdScan] = [ScanResult].[Id] WHERE [ScanResult].[IdImageList] IS NOT NULL AND [ScanAppInfo].[Image] IS NOT NULL AND [ScanAppInfo].[Image] <> -1" SQL_SEL_UNKNOWNAPPINFO_IMAGEINFO "SELECT [ScanResult].[IdImageList] AS [ScanResultImageListID], [UnknownAppInfo].[Image] AS [UnknownAppInfoImage], [UnknownAppInfo].[IdIcon] AS [UnknownAppInfoIdIcon] FROM [ScanResult] RIGHT JOIN [UnknownAppInfo] ON [UnknownAppInfo].[IdScan] = [ScanResult].[Id] WHERE [ScanResult].[IdImageList] IS NOT NULL AND [UnknownAppInfo].[Image] IS NOT NULL AND [UnknownAppInfo].[Image] <> -1" SQL_SEL_SCANFILEINFO_IMAGEINFO "SELECT [ScanResult].[IdImageList] AS [ScanResultImageListID], [ScanFileInfo].[Icon] AS [ScanFileInfoIcon], [ScanFileInfo].[IdIcon] AS [ScanFileInfoIdIcon] FROM [ScanResult] RIGHT JOIN [ScanFileInfo] ON [ScanFileInfo].[IdScan] = [ScanResult].[Id] WHERE [ScanResult].[IdImageList] IS NOT NULL AND [ScanFileInfo].[Icon] IS NOT NULL AND [ScanFileInfo].[Icon] <> -1" SQL_SEL_UNKNOWNAPP_IMAGEINFO "SELECT [UnknownApp].[IdImageList] AS [UnknownAppImageListID], [UnknownApp].[Image] AS [UnknownAppImage], [UnknownApp].[IdIcon] AS [UnknownAppIdIcon] FROM [UnknownApp] WHERE [UnknownApp].[IdImageList] IS NOT NULL AND [UnknownApp].[Image] IS NOT NULL AND [UnknownApp].[Image] <> -1" SQL_SEL_ICONID_IN "SELECT [Id] FROM [Icon] WHERE [Id] IN ( %s )" // Update section SQL_SUMMARY_PREP_PRINT_SCANAPP "UPDATE [ScanAppInfo] SET [NoPrint] = 0 WHERE [NoPrint] = 1 AND [Omit] = %s AND [IdScan] IN (%s) AND [IdApp] IN ( SELECT [IdApp] FROM [ScanAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdApp] )" SQL_SUMMARY_PREP_PRINT_UNKNOWNAPP "UPDATE [UnknownAppInfo] SET [NoPrint] = 0 WHERE [NoPrint] = 1 AND [Omit] = %s AND [IdScan] IN (%s) AND [IdApp] IN ( SELECT [IdApp] FROM [UnknownAppInfo] WHERE [NoPrint] = 0 AND [Omit] = %s AND [IdScan] IN (%s) GROUP BY [IdApp] )" SQL_SUMMARY_PREP_PRINT_REGINFO "UPDATE [ScanRegInfo] SET [NoPrint] = 0 WHERE [NoPrint] = 1 AND [IdScan] IN (%s) AND [Name] IN ( SELECT [Name] FROM [ScanRegInfo] WHERE [NoPrint] = 0 AND [IdScan] IN (%s) GROUP BY [Name] )" SQL_UPDATE_COMPANY_PRINT_KNOWN "UPDATE [ScanAppInfo] SET [NoPrint] = %s FROM ( [KnownApp] RIGHT JOIN [ScanAppInfo] ON [KnownApp].[Id] = [ScanAppInfo].[IdApp] ) WHERE [Company] = '%s' AND [Omit] = %s AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_COMPANY_PRINT_UNKNOWN "UPDATE [UnknownAppInfo] SET [NoPrint] = %s FROM ( [UnknownApp] RIGHT JOIN [UnknownAppInfo] ON [UnknownApp].[Id] = [UnknownAppInfo].[IdApp] ) WHERE [CompanyName] = '%s' AND [Omit] = %s AND [NoVersion] = %s AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_COMPANY_PRINT_KNOWN_ALL "UPDATE [ScanAppInfo] SET [NoPrint] = %s WHERE [Omit] = %s AND [IdScan] IN ( %s ) AND [NoPrint] = %s" SQL_UPDATE_COMPANY_PRINT_UNKNOWN_ALL "UPDATE [UnknownAppInfo] SET [NoPrint] = %s WHERE [Omit] = %s AND [IdScan] IN ( %s ) AND [NoPrint] = %s" SQL_UPDATE_MULTI_APP_PRINT_KNOWN "UPDATE [ScanAppInfo] SET [NoPrint] = %s WHERE [IdApp] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_MULTI_APP_PRINT_UNKNOWN "UPDATE [UnknownAppInfo] SET [NoPrint] = %s WHERE [IdApp] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_SINGLE_APP_PRINT_KNOWN "UPDATE [ScanAppInfo] SET [NoPrint] = %s WHERE [Id] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_SINGLE_APP_PRINT_UNKNOWN "UPDATE [UnknownAppInfo] SET [NoPrint] = %s WHERE [Id] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_SCANFILE_PRINT "UPDATE [ScanFileInfo] SET [NoPrint] = %s WHERE [Id] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_SINGLE_REGAPP_PRINT "UPDATE [ScanRegInfo] SET [NoPrint] = %s WHERE [Id] IN (%s) AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_MULTI_REGAPP_PRINT "UPDATE [ScanRegInfo] SET [NoPrint] = %s WHERE [Name] = '%s' AND [Version] %s AND [IdScan] IN (%s) AND [NoPrint] = %s" SQL_UPDATE_OMIT_IN_SCANAPPINFO_BY_IDAPP "UPDATE [ScanAppInfo] SET [Omit] = %s WHERE [IdApp] IN ( %s )" // Insert section SQL_INSERT_SCANSYSTEMINFO "INSERT INTO [ScanSystemInfo] ( [IdScan], [Name], [Version], [Compilation], [IdProduct], [ProductKey] ) VALUES ( %d, %s, '%d.%d', %s, %s, %s )" SQL_INSERT_SCANREGINFO "INSERT INTO [ScanRegInfo] ( [IdScan], [NoPrint], [Name], [Version], [ProductID], [Publisher], [InstallDate] ) VALUES ( %d, %s, %s, %s, %s, %s, %d )" SQL_INSERT_SCANREGCOMPONENT "INSERT INTO [ScanRegComponent] ( [IdReg], [Path] ) VALUES ( %d, %s )" SQL_INSERT_SCANAPPINFO "INSERT INTO [ScanAppInfo] ( [IdScan], [IdApp], [AppPath], [IdIcon], [NoPrint], [Omit], [Attr], [IdPacket] ) VALUES ( %d, %d, %s, %s, %s, %s, %s, %s )" SQL_INSERT_UNKNOWNAPP "INSERT INTO [UnknownApp] ( [ExeName], [CompanyName], [FileDescription], [FileVersion], [InternalName], [LegalCopyright], [OriginalFilename], [PrivateBuild], [ProductName], [ProductVersion], [SpecialBuild], [IdIcon], [FileSize], [NoVersion], [CRC], [MD5] ) VALUES ( %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %s, %d, %s, %d, '%s' )" SQL_INSERT_UNKNOWNAPPINFO "INSERT INTO [UnknownAppInfo] ( [IdScan], [IdApp], [Path], [IdIcon], [NoPrint], [Omit], [Attr], [IdPacket] ) VALUES ( %d, %d, %s, %s, %s, %s, %s, %s )" SQL_INSERT_SCANFILEGROUP "INSERT INTO [ScanFileGroup] ( [IdScan], [Name] ) VALUES ( %d, '%s' )" SQL_INSERT_SCANFILEINFO "INSERT INTO [ScanFileInfo] ( [IdScan], [IdGroup], [Path], [Name], [IdIcon], [NoPrint], [SizeLow], [SizeHigh], [Created], [Accessed], [Wrote], [Type], [Ext] ) VALUES ( %d, %d, %s, %s, %s, %s, %d, %d, %s, %s, %s, %s, %s )" // Delete section SQL_DELETE_AUDIT "DELETE FROM [ScanResult] WHERE [Id] = %d" SQL_DELETE_SCANAPPINFO_BY_IDAPP "DELETE FROM [ScanAppInfo] WHERE [IdApp] IN ( %s )" SQL_DELETE_UNKNOWNAPP "DELETE FROM [UnknownApp] WHERE [Id] IN ( %s )" SQL_DELETE_UNKNOWNAPPINFO "DELETE FROM [UnknownAppInfo] WHERE [IdApp] IN ( %s )" SQL_DELETE_ALL_UNUSED_ICON "DELETE FROM [Icon] WHERE ( [Id] NOT IN ( SELECT [IdIcon] FROM [ScanAppInfo] WHERE [IdIcon] IS NOT NULL GROUP BY [IdIcon] ) ) AND ( [Id] NOT IN ( SELECT [IdIcon] FROM [UnknownAppInfo] WHERE [IdIcon] IS NOT NULL GROUP BY [IdIcon] ) ) AND ( [Id] NOT IN ( SELECT [IdIcon] FROM [UnknownApp] WHERE [IdIcon] IS NOT NULL GROUP BY [IdIcon] ) ) AND ( [Id] NOT IN ( SELECT [IdIcon] FROM [ScanFileInfo] WHERE [IdIcon] IS NOT NULL GROUP BY [IdIcon] ) )" SQL_TOTAL_DELETE_AUDIT "DELETE FROM [ScanResult] WHERE [IdUser] IN (%s) AND [Date] >= %s AND [Date] < %s" SQL_TOTAL_DELETE_STATLOOK "DELETE FROM [WinSession] WHERE [IdUser] IN (%s) AND [Start] >= %s AND [Exit] < %s" SQL_TOTAL_DELETE_WEBLOOK "DELETE FROM [WebSession] WHERE [IdUser] IN (%s) AND [Start] >= %s AND [Start] < %s" SQL_ICONTABLEUPDATE_INIT "UPDATE [ScanAppInfo] SET [IdIcon]=NULL;UPDATE [UnknownAppInfo] SET [IdIcon]=NULL;UPDATE [ScanFileInfo] SET [IdIcon]=NULL;UPDATE [UnknownApp] SET [IdIcon]=NULL;DELETE FROM [Icon];" SQL_ICONTABLEUPDATE_EXIT "DROP INDEX [IdImageList] ON [UnknownApp];DROP INDEX [IdImageList] ON [ScanResult];ALTER TABLE [ScanResult] DROP COLUMN [IdImageList];ALTER TABLE [ScanAppInfo] DROP COLUMN [Image];ALTER TABLE [UnknownAppInfo] DROP COLUMN [Image];ALTER TABLE [ScanFileInfo] DROP COLUMN [Icon];ALTER TABLE [UnknownApp] DROP COLUMN [Image];ALTER TABLE [UnknownApp] DROP COLUMN [IdImageList];DROP TABLE [ImageList];" // Filter section SQL_WHERE_NET_AND_NOTDEFAULT "[IdNetwork] = %ld AND [Default] <> 1" SQL_WHERE_ID "[Id] = %ld" SQL_WHERE_IDREG "[IdReg] = %ld" SQL_WHERE_NET_AND_DEFAULT "[IdNetwork] = %ld AND [Default] = 1" SQL_WHERE_NET_AND_ID "[IdNetwork] = %ld AND [Id] = %ld" SQL_WHERE_IDNET_AND_IDUSER_NOT_NULL "[IdNetwork] = %ld AND [IdUser] <> NULL" SQL_WHERE_IP "[IP] = '%s'" SQL_WHERE_IDGROUP "[IdGroup] = %ld" SQL_WHERE_IDUSER "[IdUser] = %ld" SQL_WHERE_IDUSER_AND_DATE "[IdUser] = %ld AND [Date] = %s" SQL_WHERE_IDSCAN "[IdScan] = %ld" SQL_WHERE_IDNET "[IdNetwork] = %ld" SQL_WHERE_IDAPP "[IdApp] = %ld" SQL_WHERE_IDUSER_AND_IDAPP "[IdUser] = %ld AND [IdApp] = %ld" SQL_WHERE_IDUSER_AND_START "[IdUser] = %ld AND [Start] = %s" SQL_WHERE_IDSESSION "[IdSession] = %ld" SQL_WHERE_IDUSER_AND_DATERANGE "[IdUser] = %ld AND [Start] >= %s AND [Start] <= %s" SQL_WHERE_IDUSER_AND_DATERANGE_AND_USERNAME "[IdUser] = %ld AND [Start] >= %s AND [Start] <= %s AND [UserName] LIKE '%s'" SQL_WHERE_IDUSER_AND_USERNAME "[IdUser] = %ld AND [UserName] LIKE '%s'" SQL_WHERE_IDUSER_AND_NAME "[IdUser] = %ld AND [Name] LIKE '%s'" SQL_WHERE_IDSESSION_AND_NAME "[IdSession] = %ld AND [Name] LIKE '%s'" SQL_WHERE_GUID "[GUID] LIKE '%s'" SQL_WHERE_NAME "[Name] = '%s'" SQL_WHERE_ALIAS "[Alias] = '%s'" SQL_WHERE_IDSESSION_AND_APPID "[IdSession] = %ld AND [IdApp] = %ld" SQL_WHERE_IDNET_AND_IDGROUP "[IdNetwork] = %d AND [IdGroup] = %d" SQL_WHERE_IDSCAN_AND_IDAPP "[IdScan] = %ld AND [IdApp] = %ld" SQL_WHERE_IDSCAN_IN_AND_OMIT "[IdScan] IN (%s) AND [Omit] = %s" SQL_WHERE_ID_IN "[Id] IN (%s)" SQL_WHERE_IDSCAN_AND_OMIT "[IdScan] = %d AND [Omit] = %s" SQL_WHERE_ID_IN_AND_NOPRINT "[Id] IN (%s) AND [NoPrint] = %s" SQL_WHERE_IDSCAN_IN "[IdScan] IN (%s)" SQL_WHERE_IDSCAN_IN_AND_ID_IN "[IdScan] IN (%s) AND [Id] IN (%s)" SQL_WHERE_IDSCAN_IN_AND_PRINTABLE_AND_OMIT "[IdScan] IN (%s) AND [NoPrint] = 0 AND [Omit] = %s" SQL_WHERE_IDSCAN_IN_AND_PRINTABLE "[IdScan] IN (%s) AND [NoPrint] = 0" SQL_WHERE_IDSCAN_IN_AND_OSNAME_NOTNULL "[IdScan] IN ( %s) AND [OsName] IS NOT NULL AND [OsName] <> ''" SQL_WHERE_IDAPP_IN "[IdApp] IN (%s)" SQL_WHERE_COMPANYNAME "[CompanyName] = '%s'" SQL_WHERE_ID_IN_AND_COMPANYNAME "[Id] IN (%s) AND [CompanyName] = '%s'" SQL_WHERE_URL "[URL] = '%s'" SQL_WHERE_IDSESSION_AND_IDSITE_AND_START "[IdSession] = %ld AND [IdSite] = %ld AND [Start] = %s" SQL_WHERE_IDSCAN_IN_2 "[IdScan] IN (%d, %d)" SQL_WHERE_DNSNAME "[DNSName] = '%s'" SQL_WHERE_IDNET_IN_AND_IDUSER_NOT_NULL "[IdNetwork] IN (%s) AND [IdUser] <> NULL" SQL_WHERE_IDUSER_AND_START_LESS "[IdUser] = %ld AND [Start] <= %s" SQL_AND_ACTIVETIME " AND [ActiveTime] >= 1000" SQL_AND_NAME " AND [Name] LIKE '%s'" SQL_AND_FORETIME " AND [ForeTime] >= 1.0" SQL_PRINT_WHERE_IDSCAN_AND_OMIT "[NoPrint] = 0 AND [IdScan] = %ld AND [Omit] = %s" SQL_PRINT_WHERE_IDSCAN "[NoPrint] = 0 AND [IdScan] = %ld" SQL_PRINT_WHERE_IDSCAN_IN_AND_OMIT "[NoPrint] = 0 AND [IdScan] IN (%s) AND [Omit] = %s" SQL_PRINT_WHERE_IDSCAN_IN "[NoPrint] = 0 AND [IdScan] IN (%s)" SQL_AND_TITLE_OR_URL " AND ( [Title] LIKE '%%%s%%' OR [URL] LIKE '%%%s%%' )" SQL_PRINT_WHERE_IDGROUP "[NoPrint] = 0 AND [IdGroup] = %d" SQL_AND_CRC " AND [CRC] = " SQL_WHERE_IP_AND_DNSNAME "[IP] %s AND [DNSName] %s" SQL_SEARCH_USER_FILTER "[NameUser] LIKE '%%%s%%' OR [IP] LIKE '%%%s%%' OR [DNSName] LIKE '%%%s%%'" SQL_USERGUID_IS_NOT_NULL "[UserGuid] IS NOT NULL" SQL_WHERE_USER_NAME_DUPLICATED "[IdGroup]=%u AND [IdUser]<>%u AND [NameUser]='%s'" SQL_WHERE_USER_IP_DUPLICATED "[IdUser]<>%u AND [ConnectMode]=%u AND [IP]='%s'" SQL_WHERE_USER_DNSNAME_DUPLICATED "[IdUser]<>%u AND [ConnectMode]=%u AND [DNSName]='%s'" SQL_WHERE_NETWORK_NAME_DUPLICATED "[Id]<>%u AND [Name]='%s'" SQL_WHERE_GROUP_NAME_DUPLICATED "[IdNetwork]=%u AND [IdGroup]<>%u AND [NameGroup]='%s'" SQL_WHERE_KNOWNAPP_COMPANY_EQUALS_TO "WHERE [KnownApp].[Company]='%s' " SQL_WHERE_UNKNOWNAPP_COMPANY_EQUALS_TO "WHERE [UnknownApp].[CompanyName]='%s' " SQL_WHERE_KNOWNAPP_FILTERLIST "AND [KnownApp].[Id] IN ( %s );AND [KnownApp].[Company] LIKE '%%%s%%' ;AND [KnownApp].[Name] LIKE '%%%s%%' ;AND [ScanAppInfo].[Omit]=%s ;" SQL_WHERE_UNKNOWNAPP_FILTERLIST "AND [UnknownApp].[Id] IN ( %s );AND [UnknownApp].[CompanyName] LIKE '%%%s%%' ;AND ( ( [UnknownApp].[NoVersion]=%s AND [UnknownApp].[FileDescription] LIKE '%%%s%%' ) OR ( [UnknownApp].[NoVersion]=%s AND [UnknownApp].[ExeName] LIKE '%%%s%%' ) ) ;AND [UnknownAppInfo].[Omit]=%s ;" SQL_WHERE_REGISTRYAPP_FILTERLIST "AND [ScanRegInfo].[Publisher] LIKE '%%%s%%' ;AND [ScanRegInfo].[Name] LIKE '%%%s%%' ;" SQL_WHERE_IDNETWORK_IN "[IdNetwork] IN (%s)" SQL_WHERE_IDGROUP_IN "[IdGroup] IN (%s)" // Sort section SQL_SORT_BY_NAME "[Name]" SQL_SORT_BY_DATE_DESC "[Date] DESC" SQL_SORT_BY_COMPANY_APP "[Company], [Application]" SQL_SORT_BY_NAME_IP "[Name], [IP]" SQL_SORT_BY_NAMEUSER_IP "[NameUser], [IP]" SQL_SORT_BY_STARTTIME "[Start]" SQL_SORT_BY_USERNAME "[UserName]" SQL_SORT_BY_ACTIVETIME_DESC "[ActiveTime] DESC" SQL_SORT_BY_FORETIME_DESC "[ForeTime] DESC" SQL_SORT_BY_APPNAME "[AppName]" SQL_SORT_BY_START_DESC "[Start] DESC" SQL_SORT_BY_ALIAS "[Alias]" SQL_SORT_BY_IDAPP "[IdApp]" SQL_SORT_BY_APPCOMPANY "[AppCompany]" SQL_SORT_BY_APPCOMPANY_APPNAME_APPVERSION "[AppCompany], [AppName], [AppVersion]" SQL_SORT_BY_COMPANYNAME "[CompanyName]" SQL_SORT_BY_COMPANYNAME_NOVERSION "[CompanyName], [NoVersion] DESC" SQL_SORT_BY_OMIT_IDAPP_NOPRINT_DESC "[Omit] DESC, [IdApp], [NoPrint] ASC" SQL_SORT_BY_NAME_VERSION_NOPRINT_DESC "[Name], [Version], [NoPrint] ASC" SQL_SORT_REPORT_KNOWN_BY_APP "[AppCompany], [AppName], [AppVersion], [IdApp], [NameUser], [IdUser]" SQL_SORT_REPORT_KNOWN_BY_USER "[NameUser], [IdUser], [AppCompany], [AppName], [AppVersion], [IdApp]" SQL_SORT_REPORT_UNKNOWN_BY_APP "[NoVersion] DESC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [IdApp], [NameUser], [IdUser]" SQL_SORT_REPORT_UNKNOWN_BY_USER "[NameUser], [IdUser], [NoVersion] DESC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [IdApp]" SQL_SORT_REPORT_REGISTRY_BY_APP "[Name], [Version], [NameUser], [IdUser]" SQL_SORT_REPORT_REGISTRY_BY_USER "[NameUser], [IdUser], [Name], [Version]" SQL_SORT_REPORT_SYSTEM_BY_APP "[Version], [OsName], [NameUser], [IdUser], [Compilation]" SQL_SORT_REPORT_SYSTEM_BY_USER "[NameUser], [IdUser], [Version], [OsName], [Compilation]" SQL_SORT_BY_URL "[URL]" SQL_SORT_BY_TITLE "[Title]" SQL_SORT_BY_URL_TITLE_USER "[URL], [Title], [UserName]" SQL_SORT_BY_NAME_AND_PATH "[Name], [Path]" SQL_SORT_BY_START_USERNAME "[Start], [UserName]" SQL_SORT_BY_START_NAME_USERNAME "[Start], [Name], [UserName]" SQL_SORT_BY_NET_GROUP_USER "[NameNetwork], [DefGroup] ASC, [NameGroup], [NameUser]" SQL_SORT_BY_TOTALTIME_DESC "[TotalTime] DESC" SQL_SORT_KNOWNAPP_ORDERBY_LIST "ORDER BY ;[KnownApp].[Company], ;[KnownApp].[Company] DESC, ;[KnownApp].[Name], ;[KnownApp].[Name] DESC, ;[KnownApp].[Version], ;[KnownApp].[Version] DESC, ;" SQL_SORT_UNKNOWNAPP_ORDERBY_LIST "ORDER BY ;[UnknownApp].[CompanyName], ;[UnknownApp].[CompanyName] DESC, ;[UnknownApp].[FileDescription], [UnknownApp].[ExeName], ;[UnknownApp].[FileDescription] DESC, [UnknownApp].[ExeName] DESC, ;[UnknownApp].[FileVersion], ;[UnknownApp].[FileVersion] DESC, ;" SQL_SORT_SCANRESULTDATE_DESC "[Date] DESC" // Sort list section SQL_SORT_FULLREPORT "[Date], [NameUser], [IP], [Host], [GUID], [AppCompany], [AppName], [AppVersion], [PacketName], [AppPath];[Date], [NameUser], [IP], [Host], [GUID], [CompanyName], [FileDescription], [FileVersion], [ExeName], [Path];[Date], [NameUser], [IP], [Host], [GUID], [AppCompany], [AppName], [AppVersion], [PacketName], [AppPath];[Date], [NameUser], [IP], [Host], [GUID], [CompanyName], [FileDescription], [FileVersion], [ExeName], [Path];[Date], [NameUser], [IP], [Host], [GUID], [Name], [Version], [ProductID], [Publisher], [InstallDate];[Date], [NameUser], [IP], [Host], [GUID], [OsName], [Version], [Compilation], [IdProduct]" SQL_TLOG_SORT_ASC "[UserName], [Start];[Start], [UserName];[Exit], [UserName];[TotalTime], [Start], [UserName];[Active], [UserName], [Start];[KeyCount], [UserName], [Start];[ClickCount], [UserName], [Start]" SQL_TLOG_SORT_DESC "[UserName] DESC, [Start];[Start] DESC, [UserName];[Exit] DESC, [UserName];[TotalTime] DESC, [Start], [UserName];[Active] DESC, [UserName], [Start];[KeyCount] DESC, [UserName], [Start];[ClickCount] DESC, [UserName], [Start]" SQL_TEVE_SORT_ASC "[Name], [Start];[UserName], [Name], [Start];[Start], [Name], [UserName];[Exit], [Name], [UserName];[Activity], [Name], [Start];[ActiveTime], [Name], [Start];[KeyCount], [Name], [Start];[ClickCount], [Name], [Start]" SQL_TEVE_SORT_DESC "[Name] DESC, [Start];[UserName] DESC, [Name], [Start];[Start] DESC, [Name], [UserName];[Exit] DESC, [Name], [UserName];[Activity] DESC, [Name], [Start];[ActiveTime] DESC, [Name], [Start];[KeyCount] DESC, [Name], [Start];[ClickCount] DESC, [Name], [Start]" SQL_TLOGS_SORT_ASC "[UserName];[TotalTime], [UserName];[ActiveTime], [UserName];[Activity], [UserName];[KeyCount], [UserName];[ClickCount], [UserName]" SQL_TLOGS_SORT_DESC "[UserName] DESC;[TotalTime] DESC, [UserName];[ActiveTime] DESC, [UserName];[Activity] DESC, [UserName];[KeyCount] DESC, [UserName];[ClickCount] DESC, [UserName]" SQL_TEVES_SORT_ASC "[Name];[TotalTime], [Name];[ForeTime], [Name];[ActiveTime], [Name];[Activity], [Name];[KeyCount], [Name];[ClickCount], [Name]" SQL_TEVES_SORT_DESC "[Name] DESC;[TotalTime] DESC, [Name];[ForeTime] DESC, [Name];[ActiveTime] DESC, [Name];[Activity] DESC, [Name];[KeyCount] DESC, [Name];[ClickCount] DESC, [Name]" SQL_UALIST_SORT_ASC "[CompanyName], [FileDescription], [FileVersion], [ExeName];[FileDescription], [FileVersion], [ExeName], [CompanyName];[ExeName], [FileDescription], [FileVersion], [CompanyName]" SQL_UALIST_SORT_DESC "[CompanyName] DESC, [FileDescription], [FileVersion], [ExeName];[FileDescription] DESC, [FileVersion] DESC, [ExeName] DESC, [CompanyName];[ExeName] DESC, [FileDescription], [FileVersion], [CompanyName]" SQL_ALIAS_SORT_ASC "[Name], [Alias];[Alias], [Name]" SQL_ALIAS_SORT_DESC "[Name] DESC, [Alias];[Alias] DESC, [Name]" SQL_KNOWNRES_SINGLE_SORT_ASC ";[NoPrint] ASC, [AppCompany], [AppName], [AppVersion], [PacketName], [AppPath];[AppCompany], [AppName], [AppVersion], [PacketName], [AppPath];[AppName], [AppVersion], [AppCompany], [PacketName], [AppPath];[PacketName], [AppCompany], [AppName], [AppVersion], [AppPath];;[AppPath], [AppCompany], [AppName], [AppVersion], [PacketName]" SQL_KNOWNRES_SINGLE_SORT_DESC ";[NoPrint] DESC, [AppCompany], [AppName], [AppVersion], [PacketName], [AppPath];[AppCompany] DESC, [AppName], [AppVersion], [PacketName], [AppPath];[AppName] DESC, [AppVersion] DESC, [AppCompany], [PacketName], [AppPath];[PacketName] DESC, [AppCompany], [AppName], [AppVersion], [AppPath];;[AppPath] DESC, [AppCompany], [AppName], [AppVersion], [PacketName]" SQL_UNKNOWNRES_SINGLE_SORT_ASC ";[NoPrint] ASC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [Name], [Path];[CompanyName], [FileDescription], [FileVersion], [ExeName], [Name], [Path];[FileDescription], [FileVersion], [ExeName], [CompanyName], [Name], [Path];[Name], [CompanyName], [FileDescription], [FileVersion], [ExeName], [Path];;[Path], [CompanyName], [FileDescription], [FileVersion], [ExeName], [Name]" SQL_UNKNOWNRES_SINGLE_SORT_DESC ";[NoPrint] DESC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [Name], [Path];[CompanyName] DESC, [FileDescription], [FileVersion], [ExeName], [Name], [Path];[FileDescription] DESC, [FileVersion] DESC, [ExeName] DESC, [CompanyName], [Name], [Path];[Name] DESC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [Path];;[Path] DESC, [CompanyName], [FileDescription], [FileVersion], [ExeName], [Name]" SQL_REGRES_SINGLE_SORT_ASC ";[NoPrint] ASC, [Name], [Version], [ProductID], [Publisher], [InstallDate];[Name], [Version], [ProductID], [Publisher], [InstallDate];[Version], [Name], [ProductID], [Publisher], [InstallDate];[ProductID], [Name], [Version], [Publisher], [InstallDate];[Publisher], [Name], [Version], [ProductID], [InstallDate];[InstallDate], [Name], [Version], [ProductID], [Publisher]" SQL_REGRES_SINGLE_SORT_DESC ";[NoPrint] DESC, [Name], [Version], [ProductID], [Publisher], [InstallDate];[Name] DESC, [Version], [ProductID], [Publisher], [InstallDate];[Version] DESC, [Name], [ProductID], [Publisher], [InstallDate];[ProductID] DESC, [Name], [Version], [Publisher], [InstallDate];[Publisher] DESC, [Name], [Version], [ProductID], [InstallDate];[InstallDate] DESC, [Name], [Version], [ProductID], [Publisher]" SQL_REGRES_MULTI_SORT_ASC "[NoPrint] ASC, [Name], [Version];[Name], [Version]" SQL_REGRES_MULTI_SORT_DESC "[NoPrint] DESC, [Name], [Version];[Name] DESC, [Version] DESC" SQL_TWHI_SORT_ASC "[UserName], [Start], [Title], [URL], [WorkTime];[Start], [Title], [URL], [WorkTime], [UserName];[WorkTime], [Title], [URL], [Start], [UserName];[Title], [URL], [UserName], [Start], [WorkTime];[URL], [Title], [UserName], [Start], [WorkTime]" SQL_TWHI_SORT_DESC "[UserName] DESC, [Start], [Title], [URL], [WorkTime];[Start] DESC, [Title], [URL], [WorkTime], [UserName];[WorkTime] DESC, [Title], [URL], [Start], [UserName];[Title] DESC, [URL], [UserName], [Start], [WorkTime];[URL] DESC, [Title], [UserName], [Start], [WorkTime]" SQL_TWSU_SORT_ASC "[UserName], [TotalTime], [Title], [URL];[TotalTime], [Title], [URL], [UserName];[Title], [URL], [UserName], [TotalTime];[URL], [Title], [UserName], [TotalTime]" SQL_TWSU_SORT_DESC "[UserName] DESC, [TotalTime], [Title], [URL];[TotalTime] DESC, [Title], [URL], [UserName];[Title] DESC, [URL], [UserName], [TotalTime];[URL] DESC, [Title], [UserName], [TotalTime]" SQL_FILERES_SORT_ASC "[Name], [Path];[NoPrint] ASC, [Name], [Path];[Name], [Path];[Type], [Name];[SizeHigh], [SizeLow], [Name], [Path];[Created], [Name], [Path];[Accessed], [Name], [Path];[Wrote], [Name], [Path];[Path], [Name]" SQL_FILERES_SORT_DESC "[Name] DESC, [Path];[NoPrint] DESC, [Name], [Path];[Name] DESC, [Path];[Type] DESC, [Name];[SizeHigh] DESC, [SizeLow] DESC, [Name], [Path];[Created] DESC, [Name], [Path];[Accessed] DESC, [Name], [Path];[Wrote] DESC, [Name], [Path];[Path] DESC, [Name]" SQL_KNOWNRES_MULTI_SORT_ASC "[NoPrint] ASC, [AppName], [AppVersion];[AppName], [AppVersion]" SQL_KNOWNRES_MULTI_SORT_DESC "[NoPrint] DESC, [AppName], [AppVersion];[AppName] DESC, [AppVersion] DESC" SQL_UNKNOWNRES_MULTI_SORT_ASC "[NoPrint] ASC, [AppDesc], [ExeName], [AppVersion];[AppDesc], [ExeName], [AppVersion]" SQL_UNKNOWNRES_MULTI_SORT_DESC "[NoPrint] DESC, [AppDesc], [ExeName], [AppVersion];[AppDesc] DESC, [ExeName] DESC, [AppVersion] DESC" // Format section SQL_FORMAT_DATETIME "'%Y/%m/%d %H:%M:%S'" SQL_IS_NULL "IS NULL" // Tools section SQL_GET_DATABASES "SELECT * FROM master..sysdatabases ORDER BY name" SQL_FIND_DATABASE "SELECT * FROM master..sysdatabases WHERE name = '%s'" SQL_CREATE_DATABASE "IF EXISTS ( SELECT * FROM master..sysdatabases WHERE NAME = '%s' ) DROP DATABASE [%s];CREATE DATABASE [%s]" SQL_GET_DATABASE_SIZE "SELECT SUM([size]) AS dbSize FROM [sysfiles]" SQL_FIELD_DBSIZE "dbSize" SQL_FIELD_DBNAME "name" SQL_FACTOR_DBSIZE "8192" SQL_GET_IDENTITY "SELECT Max([%field%]) AS [NextId] FROM [%table%]" SQL_GET_RECORD_COUNT "Select Count(*) AS [RecordCount] FROM [%s]" SQL_IMPORT_AUDIT_DROP_INDEXES "DROP INDEX [ScanAppInfo].[AppPath]; DROP INDEX [ScanAppInfo].[NoPrint]; DROP INDEX [ScanAppInfo].[Omit]; DROP INDEX [ScanAppInfo].[IdPacket]; DROP INDEX [ScanAppInfo].[IdIcon]; DROP INDEX [UnknownAppInfo].[Path]; DROP INDEX [UnknownAppInfo].[NoPrint]; DROP INDEX [UnknownAppInfo].[Omit]; DROP INDEX [UnknownAppInfo].[IdPacket]; DROP INDEX [UnknownAppInfo].[IdIcon]; DROP INDEX [ScanSystemInfo].[Name]; DROP INDEX [ScanSystemInfo].[Version]; DROP INDEX [ScanSystemInfo].[Compilation]; DROP INDEX [ScanSystemInfo].[ProductKey]; DROP INDEX [ScanRegInfo].[NoPrint]; DROP INDEX [ScanRegComponent].[Path]; DROP INDEX [ScanFileGroup].[Name]; DROP INDEX [ScanFileInfo].[NoPrint]; DROP INDEX [ScanFileInfo].[Name]; DROP INDEX [ScanFileInfo].[Path]; DROP INDEX [ScanFileInfo].[Type]; DROP INDEX [ScanFileInfo].[FileSize]; DROP INDEX [ScanFileInfo].[Created]; DROP INDEX [ScanFileInfo].[Accessed]; DROP INDEX [ScanFileInfo].[Wrote]; DROP INDEX [ScanFileInfo].[IdIcon]; DROP INDEX [UnknownApp].[ExeName]; DROP INDEX [UnknownApp].[CompanyName]; DROP INDEX [UnknownApp].[FileVersion]; DROP INDEX [UnknownApp].[FileDescription]; DROP INDEX [UnknownApp].[NoVersion]; DROP INDEX [UnknownApp].[CRC]; DROP INDEX [UnknownApp].[IdIcon];" SQL_IMPORT_AUDIT_RESTORE_INDEXES "CREATE INDEX [AppPath] ON [ScanAppInfo] ( [AppPath] );CREATE INDEX [NoPrint] ON [ScanAppInfo] ( [NoPrint] );CREATE INDEX [Omit] ON [ScanAppInfo] ( [Omit] );CREATE INDEX [IdPacket] ON [ScanAppInfo] ( [IdPacket] );CREATE INDEX [IdIcon] ON [ScanAppInfo] ( [IdIcon] );CREATE INDEX [Path] ON [UnknownAppInfo] ( [Path] );CREATE INDEX [NoPrint] ON [UnknownAppInfo] ( [NoPrint] );CREATE INDEX [Omit] ON [UnknownAppInfo] ( [Omit] );CREATE INDEX [IdPacket] ON [UnknownAppInfo] ( [IdPacket] );CREATE INDEX [IdIcon] ON [UnknownAppInfo] ( [IdIcon] );CREATE INDEX [Name] ON [ScanSystemInfo] ( [Name] );CREATE INDEX [Version] ON [ScanSystemInfo] ( [Version] );CREATE INDEX [Compilation] ON [ScanSystemInfo] ( [Compilation] );CREATE INDEX [ProductKey] ON [ScanSystemInfo] ( [ProductKey] );CREATE INDEX [NoPrint] ON [ScanRegInfo] ( [NoPrint] );CREATE INDEX [Path] ON [ScanRegComponent] ( [Path] );CREATE INDEX [Name] ON [ScanFileGroup] ( [Name] );CREATE INDEX [NoPrint] ON [ScanFileInfo] ( [NoPrint] );CREATE INDEX [Name] ON [ScanFileInfo] ( [Name] );CREATE INDEX [Path] ON [ScanFileInfo] ( [Path] );CREATE INDEX [Type] ON [ScanFileInfo] ( [Type] );CREATE INDEX [FileSize] ON [ScanFileInfo] ( [SizeHigh], [SizeLow] );CREATE INDEX [Created] ON [ScanFileInfo] ( [Created] );CREATE INDEX [Accessed] ON [ScanFileInfo] ( [Accessed] );CREATE INDEX [Wrote] ON [ScanFileInfo] ( [Wrote] );CREATE INDEX [IdIcon] ON [ScanFileInfo] ( [IdIcon] );CREATE INDEX [ExeName] ON [UnknownApp] ( [ExeName] );CREATE INDEX [CompanyName] ON [UnknownApp] ( [CompanyName] );CREATE INDEX [FileVersion] ON [UnknownApp] ( [FileVersion] );CREATE INDEX [FileDescription] ON [UnknownApp] ( [FileDescription] );CREATE INDEX [NoVersion] ON [UnknownApp] ( [NoVersion] );CREATE INDEX [CRC] ON [UnknownApp] ( [CRC] );CREATE INDEX [IdIcon] ON [UnknownApp] ( [IdIcon] );" SQL_COMPACT_DATABASE "DBCC SHRINKDATABASE ( [%s] )" SQL_GET_DATABASE_NAME "SELECT DB_NAME()" SQL_GET_TABLES "SELECT [name] from sysobjects WHERE type = 'U' ORDER BY [name]" SQL_RENAME_TABLE "EXEC sp_rename '%s', '%s'" SQL_RENAME_FIELD "EXEC sp_rename '%s.%s', '%s'" // New Database section <SQL_NEW_DATABASE> CREATE TABLE [_Anubis_Master_2000_] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [Settings] VARCHAR(255) ); CREATE TABLE [AppAlias] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [Name] VARCHAR(64) NOT NULL, [Alias] VARCHAR(64) NOT NULL ); CREATE UNIQUE INDEX [Name] ON [AppAlias] ( [Name] ); CREATE INDEX [Alias] ON [AppAlias] ( [Alias] ); CREATE TABLE [Fingerprint] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [Version] INTEGER NOT NULL, [Fingerprint] IMAGE ); CREATE UNIQUE INDEX [Version] ON [Fingerprint] ( [Version] ); CREATE TABLE [Licenses] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdApp] INTEGER NOT NULL, [Licenses] INTEGER, [Company] VARCHAR(128) NOT NULL, [Application] VARCHAR(128) NOT NULL ); CREATE UNIQUE INDEX [IdApp] ON [Licenses] ( [IdApp] ); CREATE INDEX [Licenses] ON [Licenses] ( [Licenses] ); CREATE INDEX [Company] ON [Licenses] ( [Company] ); CREATE INDEX [Application] ON [Licenses] ( [Application] ); CREATE UNIQUE INDEX [Main] ON [Licenses] ( [Company], [Application] ); CREATE TABLE [Network] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [Name] VARCHAR(128) NOT NULL, [IP] VARCHAR(32), [Mask] VARCHAR(32), [Desc] NTEXT, [AgentConfig] VARCHAR(255) ); CREATE UNIQUE INDEX [Name] ON [Network] ( [Name] ); CREATE INDEX [IP] On Network ( [IP] ); CREATE INDEX [Mask] On Network ( [Mask] ); CREATE TABLE [UserGroup] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdNetwork] INTEGER NOT NULL, [Name] VARCHAR(128) NOT NULL, [Desc] NTEXT, [Default] BIT, [AgentConfig] VARCHAR(255) ); CREATE INDEX [IdNetwork] ON [UserGroup] ( [IdNetwork] ); CREATE INDEX [Name] ON [UserGroup] ( [Name] ); CREATE INDEX [Default] ON [UserGroup] ( [Default] ); CREATE UNIQUE INDEX [Main] ON [UserGroup] ( [Name], [IdNetwork] ); ALTER TABLE [UserGroup] ADD CONSTRAINT Network_UserGroup FOREIGN KEY ( [IdNetwork] ) REFERENCES [Network] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [User] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdGroup] INTEGER NOT NULL, [Name] VARCHAR(64) NOT NULL, [IP] VARCHAR(32) NOT NULL, [Host] VARCHAR(255), [GUID] VARCHAR(64), [Desc] NTEXT, [LastScan] DATETIME, [System] VARCHAR(64), [FpVersion] INTEGER, [AgentVersion] INTEGER, [Password] VARCHAR(64), [AgentConfig] VARCHAR(255), [Hardware] IMAGE, [NoNet] BIT, [DNSName] VARCHAR(255), [ConnectMode] INTEGER, [Mac] VARCHAR(32) ); CREATE INDEX [IdGroup] ON [User] ( [IdGroup] ); CREATE INDEX [Name] ON [User] ( [Name] ); CREATE INDEX [IP] ON [User] ( [IP] ); CREATE INDEX [Host] ON [User] ( [Host] ); CREATE INDEX [GUID] ON [User] ( [GUID] ); CREATE INDEX [LastScan] ON [User] ( [LastScan] ); CREATE INDEX [System] ON [User] ( [System] ); CREATE INDEX [Password] ON [User] ( [Password] ); CREATE INDEX [NoNet] ON [User] ( [NoNet] ); CREATE INDEX [DNSName] ON [User] ( [DNSName] ); CREATE INDEX [Mac] ON [User] ( [Mac] ); ALTER TABLE [User] ADD CONSTRAINT UserGroup_User FOREIGN KEY ( [IdGroup] ) REFERENCES [UserGroup] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [WebSession] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdUser] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [UserName] VARCHAR(128) ); CREATE INDEX [IdUser] ON [WebSession] ( [IdUser] ); CREATE INDEX [Start] ON [WebSession] ( [Start] ); CREATE INDEX [UserName] ON [WebSession] ( [UserName] ); ALTER TABLE [WebSession] ADD CONSTRAINT User_WebSession FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [WebTime] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdSession] INTEGER NOT NULL, [IdSite] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [WorkTime] INTEGER NOT NULL ); CREATE INDEX [IdSession] ON [WebTime] ( [IdSession] ); CREATE INDEX [IdSite] ON [WebTime] ( [IdSite] ); CREATE INDEX [Start] ON [WebTime] ( [Start] ); CREATE INDEX [WorkTime] ON [WebTime] ( [WorkTime] ); ALTER TABLE [WebTime] ADD CONSTRAINT WebSession_WebTime FOREIGN KEY ( [IdSession] ) REFERENCES [WebSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [WebSite] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [URL] VARCHAR(255) NOT NULL, [Title] VARCHAR(255) ); CREATE UNIQUE INDEX [URL] ON [WebSite] ( [URL] ); CREATE INDEX [Title] ON [WebSite] ( [Title] ); CREATE TABLE [Rights] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdUser] INTEGER NOT NULL, [IdApp] INTEGER NOT NULL ); CREATE INDEX [IdUser] ON [Rights] ( [IdUser] ); CREATE INDEX [IdApp] ON [Rights] ( [IdApp] ); CREATE UNIQUE INDEX [Main] ON [Rights] ( [IdApp], [IdUser] ); ALTER TABLE [Rights] ADD CONSTRAINT User_Rights FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [WinSession] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdUser] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [Exit] DATETIME NOT NULL, [InactiveTable] IMAGE, [ActiveTable] IMAGE, [UserName] VARCHAR(255), [KeyCount] INTEGER, [ClickCount] INTEGER, [Active] FLOAT, [TotalTime] INTEGER NOT NULL ); CREATE INDEX [IdUser] ON [WinSession] ( [IdUser] ); CREATE INDEX [Start] ON [WinSession] ( [Start] ); CREATE INDEX [Exit] ON [WinSession] ( [Exit] ); CREATE INDEX [UserName] ON [WinSession] ( [UserName] ); CREATE INDEX [KeyCount] ON [WinSession] ( [KeyCount] ); CREATE INDEX [ClickCount] ON [WinSession] ( [ClickCount] ); CREATE INDEX [Active] ON [WinSession] ( [Active] ); CREATE INDEX [TotalTime] ON [WinSession] ( [TotalTime] ); ALTER TABLE [WinSession] ADD CONSTRAINT User_WinSession FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [AppSessionSum] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdSession] INTEGER NOT NULL, [KeyCount] INTEGER NOT NULL, [ClickCount] INTEGER NOT NULL, [TotalTime] INTEGER NOT NULL, [ActiveTime] INTEGER NOT NULL, [ForeTime] INTEGER NOT NULL, [Activity] FLOAT, [IdApp] INTEGER ); CREATE INDEX [IdSession] ON [AppSessionSum] ( [IdSession] ); CREATE INDEX [KeyCount] ON [AppSessionSum] ( [KeyCount] ); CREATE INDEX [ClickCount] ON [AppSessionSum] ( [ClickCount] ); CREATE INDEX [TotalTime] ON [AppSessionSum] ( [TotalTime] ); CREATE INDEX [ActiveTime] ON [AppSessionSum] ( [ActiveTime] ); CREATE INDEX [ForeTime] ON [AppSessionSum] ( [ForeTime] ); CREATE INDEX [Activity] ON [AppSessionSum] ( [Activity] ); CREATE INDEX [IdApp] ON [AppSessionSum] ( [IdApp] ); ALTER TABLE [AppSessionSum] ADD CONSTRAINT WinSession_AppSessionSum FOREIGN KEY ( [IdSession] ) REFERENCES [WinSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [App] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [Name] VARCHAR(64) NOT NULL, [Alias] VARCHAR(64) NOT NULL ); CREATE UNIQUE INDEX [Name] ON [App] ( [Name] ); CREATE INDEX [Alias] ON [App] ( [Alias] ); CREATE TABLE [AppSession] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdSession] INTEGER NOT NULL, [Start] DATETIME NOT NULL, [Exit] DATETIME NOT NULL, [StartTick] INTEGER, [IdProcess] INTEGER, [TotalTime] INTEGER NOT NULL, [ActiveTime] INTEGER NOT NULL, [DeadTime] INTEGER NOT NULL, [Activity] FLOAT NOT NULL, [KeyCount] INTEGER, [ClickCount] INTEGER, [IdApp] INTEGER ); CREATE INDEX [IdSession] ON [AppSession] ( [IdSession] ); CREATE INDEX [Start] ON [AppSession] ( [Start] ); CREATE INDEX [Exit] ON [AppSession] ( [Exit] ); CREATE INDEX [StartTick] ON [AppSession] ( [StartTick] ); CREATE INDEX [IdProcess] ON [AppSession] ( [IdProcess] ); CREATE INDEX [TotalTime] ON [AppSession] ( [TotalTime] ); CREATE INDEX [ActiveTime] ON [AppSession] ( [ActiveTime] ); CREATE INDEX [DeadTime] ON [AppSession] ( [DeadTime] ); CREATE INDEX [Activity] ON [AppSession] ( [Activity] ); CREATE INDEX [KeyCount] ON [AppSession] ( [KeyCount] ); CREATE INDEX [ClickCount] ON [AppSession] ( [ClickCount] ); CREATE INDEX [IdApp] ON [AppSession] ( [IdApp] ); ALTER TABLE [AppSession] ADD CONSTRAINT WinSession_AppSession FOREIGN KEY ( [IdSession] ) REFERENCES [WinSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [Icon] ( [Id] INTEGER NOT NULL PRIMARY KEY, [Icon] IMAGE NOT NULL ); CREATE TABLE [KnownApp] ( [Id] INTEGER PRIMARY KEY NOT NULL, [Company] VARCHAR(128), [Name] VARCHAR(128), [Version] VARCHAR(64), [ExeName] VARCHAR(64) ); CREATE UNIQUE INDEX [Id] ON [KnownApp] ( [Id] ); CREATE INDEX [Company] ON [KnownApp] ( [Company] ); CREATE INDEX [Name] ON [KnownApp] ( [Name] ); CREATE INDEX [Version] ON [KnownApp] ( [Version] ); CREATE INDEX [ExeName] ON [KnownApp] ( [ExeName] ); CREATE INDEX [Main] ON [KnownApp] ( [Company], [Name], [Version] ); CREATE TABLE [ScanResult] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdUser] INTEGER NOT NULL, [Date] DATETIME NOT NULL, [Mode] INTEGER NOT NULL, [Hardware] IMAGE, [Desc] NTEXT, [Extra1] VARCHAR(255), [Extra2] VARCHAR(255), [Extra3] VARCHAR(255), [Extra4] VARCHAR(255), [Extra5] VARCHAR(255), [Label1] VARCHAR(64), [Label2] VARCHAR(64), [Label3] VARCHAR(64), [Label4] VARCHAR(64), [Label5] VARCHAR(64) ); CREATE INDEX [IdUser] ON [ScanResult] ( [IdUser] ); CREATE INDEX [Date] ON [ScanResult] ( [Date] ); CREATE INDEX [Mode] ON [ScanResult] ( [Mode] ); ALTER TABLE [ScanResult] ADD CONSTRAINT User_ScanResult FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [ScanAppInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [IdApp] INTEGER NOT NULL, [AppPath] VARCHAR(255), [NoPrint] BIT, [Omit] BIT, [Attr] IMAGE, [IdPacket] INTEGER, [IdIcon] INTEGER ); CREATE INDEX [IdScan] ON [ScanAppInfo] ( [IdScan] ); CREATE INDEX [IdApp] ON [ScanAppInfo] ( [IdApp] ); CREATE INDEX [AppPath] ON [ScanAppInfo] ( [AppPath] ); CREATE INDEX [NoPrint] ON [ScanAppInfo] ( [NoPrint] ); CREATE INDEX [Omit] ON [ScanAppInfo] ( [Omit] ); CREATE INDEX [IdPacket] ON [ScanAppInfo] ( [IdPacket] ); CREATE INDEX [IdIcon] ON [ScanAppInfo] ( [IdIcon] ); ALTER TABLE [ScanAppInfo] ADD CONSTRAINT ScanResult_ScanAppInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE [ScanAppInfo] ADD CONSTRAINT Icon_ScanAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; CREATE TABLE [UnknownAppInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [IdApp] INTEGER NOT NULL, [Path] VARCHAR(255), [NoPrint] BIT, [Omit] BIT, [Attr] IMAGE, [IdPacket] INTEGER, [IdIcon] INTEGER ); CREATE INDEX [IdScan] ON [UnknownAppInfo] ( [IdScan] ); CREATE INDEX [IdApp] ON [UnknownAppInfo] ( [IdApp] ); CREATE INDEX [Path] ON [UnknownAppInfo] ( [Path] ); CREATE INDEX [NoPrint] ON [UnknownAppInfo] ( [NoPrint] ); CREATE INDEX [Omit] ON [UnknownAppInfo] ( [Omit] ); CREATE INDEX [IdPacket] ON [UnknownAppInfo] ( [IdPacket] ); CREATE INDEX [IdIcon] ON [UnknownAppInfo] ( [IdIcon] ); ALTER TABLE [UnknownAppInfo] ADD CONSTRAINT ScanResult_UnknownAppInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE [UnknownAppInfo] ADD CONSTRAINT Icon_UnknownAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; CREATE TABLE [ScanSystemInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [Name] VARCHAR(128), [Version] VARCHAR(32), [Compilation] VARCHAR(128), [IdProduct] VARCHAR(128), [ProductKey] VARCHAR(64) ); CREATE INDEX [IdScan] ON [ScanSystemInfo] ( [IdScan] ); CREATE INDEX [Name] ON [ScanSystemInfo] ( [Name] ); CREATE INDEX [Version] ON [ScanSystemInfo] ( [Version] ); CREATE INDEX [Compilation] ON [ScanSystemInfo] ( [Compilation] ); CREATE INDEX [ProductKey] ON [ScanSystemInfo] ( [ProductKey] ); ALTER TABLE [ScanSystemInfo] ADD CONSTRAINT ScanResult_ScanSystemInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [ScanRegInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [NoPrint] BIT, [Name] VARCHAR(128), [Version] VARCHAR(64), [ProductID] VARCHAR(64), [Publisher] VARCHAR(64), [InstallDate] INTEGER ); CREATE INDEX [IdScan] ON [ScanRegInfo] ( [IdScan] ); CREATE INDEX [NoPrint] ON [ScanRegInfo] ( [NoPrint] ); ALTER TABLE [ScanRegInfo] ADD CONSTRAINT ScanRes_ScanRegInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [ScanRegComponent] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdReg] INTEGER NOT NULL, [Path] VARCHAR(255) ); CREATE INDEX [IdReg] ON [ScanRegComponent] ( [IdReg] ); CREATE INDEX [Path] ON [ScanRegComponent] ( [Path] ); ALTER TABLE [ScanRegComponent] ADD CONSTRAINT ScanRegInfo_ScanRegComponent FOREIGN KEY ( [IdReg] ) REFERENCES [ScanRegInfo] ( [Id] )ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [ScanFileGroup] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [Name] VARCHAR(255) NOT NULL ); CREATE INDEX [IdScan] ON [ScanFileGroup] ( [IdScan] ); CREATE INDEX [Name] ON [ScanFileGroup] ( [Name] ); ALTER TABLE [ScanFileGroup] ADD CONSTRAINT ScanResult_ScanFileGroup FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE [ScanFileInfo] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [IdScan] INTEGER NOT NULL, [IdGroup] INTEGER NOT NULL, [Path] VARCHAR(255) NOT NULL, [Name] VARCHAR(32) NOT NULL, [NoPrint] BIT, [SizeLow] INTEGER NOT NULL, [SizeHigh] INTEGER NOT NULL, [Created] DATETIME, [Accessed] DATETIME, [Wrote] DATETIME, [Type] VARCHAR(64), [Ext] VARCHAR(16), [IdIcon] INTEGER ); CREATE INDEX [IdScan] ON [ScanFileInfo] ( [IdScan] ); CREATE INDEX [IdGroup] ON [ScanFileInfo] ( [IdGroup] ); CREATE INDEX [NoPrint] ON [ScanFileInfo] ( [NoPrint] ); CREATE INDEX [Name] ON [ScanFileInfo] ( [Name] ); CREATE INDEX [Path] ON [ScanFileInfo] ( [Path] ); CREATE INDEX [Type] ON [ScanFileInfo] ( [Type] ); CREATE INDEX [FileSize] ON [ScanFileInfo] ( [SizeHigh], [SizeLow] ); CREATE INDEX [Created] ON [ScanFileInfo] ( [Created] ); CREATE INDEX [Accessed] ON [ScanFileInfo] ( [Accessed] ); CREATE INDEX [Wrote] ON [ScanFileInfo] ( [Wrote] ); CREATE INDEX [IdIcon] ON [ScanFileInfo] ( [IdIcon] ); ALTER TABLE [ScanFileInfo] ADD CONSTRAINT ScanFileGroup_ScanFileInfo FOREIGN KEY ( [IdGroup] ) REFERENCES [ScanFileGroup] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE [ScanFileInfo] ADD CONSTRAINT Icon_ScanFileInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; CREATE TABLE [UnknownApp] ( [Id] INTEGER IDENTITY ( 1, 1 ) PRIMARY KEY, [ExeName] VARCHAR(64) NOT NULL, [CompanyName] VARCHAR(128) NOT NULL, [FileDescription] VARCHAR(128) NOT NULL, [FileVersion] VARCHAR(64) NOT NULL, [InternalName] VARCHAR(64) NOT NULL, [LegalCopyright] VARCHAR(128) NOT NULL, [OriginalFilename] VARCHAR(64) NOT NULL, [PrivateBuild] VARCHAR(64) NOT NULL, [ProductName] VARCHAR(128) NOT NULL, [ProductVersion] VARCHAR(64) NOT NULL, [SpecialBuild] VARCHAR(64) NOT NULL, [FileSize] INTEGER, [NoVersion] BIT, [CRC] INTEGER, [MD5] VARCHAR(40), [IdIcon] INTEGER ); CREATE INDEX [ExeName] ON [UnknownApp] ( [ExeName] ); CREATE INDEX [CompanyName] ON [UnknownApp] ( [CompanyName] ); CREATE INDEX [FileVersion] ON [UnknownApp] ( [FileVersion] ); CREATE INDEX [FileDescription] ON [UnknownApp] ( [FileDescription] ); CREATE INDEX [NoVersion] ON [UnknownApp] ( [NoVersion] ); CREATE INDEX [CRC] ON [UnknownApp] ( [CRC] ); CREATE INDEX [MD5] ON [UnknownApp] ( [MD5] ); CREATE INDEX [IdIcon] ON [UnknownApp] ( [IdIcon] ); ALTER TABLE [UnknownApp] ADD CONSTRAINT Icon_UnknownApp FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; </SQL_NEW_DATABASE> // Open Database section <SQL_OPEN_DATABASE> SET DATEFORMAT ymd; </SQL_OPEN_DATABASE> // Copy Database section <SQL_COPY_DATABASE> PRE_SQL DELETE FROM [Fingerprint]; PRE_SQL DELETE FROM [KnownApp]; PRE_SQL DROP INDEX [AppAlias].[Name]; PRE_SQL DROP INDEX [AppAlias].[Alias]; PRE_SQL DROP INDEX [Fingerprint].[Version]; PRE_SQL DROP INDEX [Licenses].[IdApp]; PRE_SQL DROP INDEX [Licenses].[Licenses]; PRE_SQL DROP INDEX [Licenses].[Company]; PRE_SQL DROP INDEX [Licenses].[Application]; PRE_SQL DROP INDEX [Licenses].[Main]; PRE_SQL DROP INDEX [Network].[Name]; PRE_SQL DROP INDEX Network.[IP]; PRE_SQL DROP INDEX Network.[Mask]; PRE_SQL DROP INDEX [UserGroup].[IdNetwork]; PRE_SQL DROP INDEX [UserGroup].[Name]; PRE_SQL DROP INDEX [UserGroup].[Default]; PRE_SQL DROP INDEX [UserGroup].[Main]; PRE_SQL DROP INDEX [User].[IdGroup]; PRE_SQL DROP INDEX [User].[Name]; PRE_SQL DROP INDEX [User].[IP]; PRE_SQL DROP INDEX [User].[Host]; PRE_SQL DROP INDEX [User].[GUID]; PRE_SQL DROP INDEX [User].[LastScan]; PRE_SQL DROP INDEX [User].[System]; PRE_SQL DROP INDEX [User].[Password]; PRE_SQL DROP INDEX [User].[NoNet]; PRE_SQL DROP INDEX [User].[DNSName]; PRE_SQL DROP INDEX [User].[Mac]; PRE_SQL DROP INDEX [WebSession].[IdUser]; PRE_SQL DROP INDEX [WebSession].[Start]; PRE_SQL DROP INDEX [WebSession].[UserName]; PRE_SQL DROP INDEX [WebTime].[IdSession]; PRE_SQL DROP INDEX [WebTime].[IdSite]; PRE_SQL DROP INDEX [WebTime].[Start]; PRE_SQL DROP INDEX [WebTime].[WorkTime]; PRE_SQL DROP INDEX [WebSite].[URL]; PRE_SQL DROP INDEX [WebSite].[Title]; PRE_SQL DROP INDEX [Rights].[IdUser]; PRE_SQL DROP INDEX [Rights].[IdApp]; PRE_SQL DROP INDEX [Rights].[Main]; PRE_SQL DROP INDEX [WinSession].[IdUser]; PRE_SQL DROP INDEX [WinSession].[Start]; PRE_SQL DROP INDEX [WinSession].[Exit]; PRE_SQL DROP INDEX [WinSession].[UserName]; PRE_SQL DROP INDEX [WinSession].[KeyCount]; PRE_SQL DROP INDEX [WinSession].[ClickCount]; PRE_SQL DROP INDEX [WinSession].[Active]; PRE_SQL DROP INDEX [WinSession].[TotalTime]; PRE_SQL DROP INDEX [AppSessionSum].[IdSession]; PRE_SQL DROP INDEX [AppSessionSum].[KeyCount]; PRE_SQL DROP INDEX [AppSessionSum].[ClickCount]; PRE_SQL DROP INDEX [AppSessionSum].[TotalTime]; PRE_SQL DROP INDEX [AppSessionSum].[ActiveTime]; PRE_SQL DROP INDEX [AppSessionSum].[ForeTime]; PRE_SQL DROP INDEX [AppSessionSum].[Activity]; PRE_SQL DROP INDEX [AppSessionSum].[IdApp]; PRE_SQL DROP INDEX [App].[Name]; PRE_SQL DROP INDEX [App].[Alias]; PRE_SQL DROP INDEX [AppSession].[IdSession]; PRE_SQL DROP INDEX [AppSession].[Start]; PRE_SQL DROP INDEX [AppSession].[Exit]; PRE_SQL DROP INDEX [AppSession].[StartTick]; PRE_SQL DROP INDEX [AppSession].[IdProcess]; PRE_SQL DROP INDEX [AppSession].[TotalTime]; PRE_SQL DROP INDEX [AppSession].[ActiveTime]; PRE_SQL DROP INDEX [AppSession].[DeadTime]; PRE_SQL DROP INDEX [AppSession].[Activity]; PRE_SQL DROP INDEX [AppSession].[KeyCount]; PRE_SQL DROP INDEX [AppSession].[ClickCount]; PRE_SQL DROP INDEX [AppSession].[IdApp]; PRE_SQL DROP INDEX [KnownApp].[Id]; PRE_SQL DROP INDEX [KnownApp].[Company]; PRE_SQL DROP INDEX [KnownApp].[Name]; PRE_SQL DROP INDEX [KnownApp].[Version]; PRE_SQL DROP INDEX [KnownApp].[ExeName]; PRE_SQL DROP INDEX [KnownApp].[Main]; PRE_SQL DROP INDEX [ScanResult].[IdUser]; PRE_SQL DROP INDEX [ScanResult].[Date]; PRE_SQL DROP INDEX [ScanResult].[Mode]; PRE_SQL DROP INDEX [ScanAppInfo].[IdScan]; PRE_SQL DROP INDEX [ScanAppInfo].[IdApp]; PRE_SQL DROP INDEX [ScanAppInfo].[AppPath]; PRE_SQL DROP INDEX [ScanAppInfo].[NoPrint]; PRE_SQL DROP INDEX [ScanAppInfo].[Omit]; PRE_SQL DROP INDEX [ScanAppInfo].[IdPacket]; PRE_SQL DROP INDEX [ScanAppInfo].[IdIcon]; PRE_SQL DROP INDEX [UnknownAppInfo].[IdScan]; PRE_SQL DROP INDEX [UnknownAppInfo].[IdApp]; PRE_SQL DROP INDEX [UnknownAppInfo].[Path]; PRE_SQL DROP INDEX [UnknownAppInfo].[NoPrint]; PRE_SQL DROP INDEX [UnknownAppInfo].[Omit]; PRE_SQL DROP INDEX [UnknownAppInfo].[IdPacket]; PRE_SQL DROP INDEX [UnknownAppInfo].[IdIcon]; PRE_SQL DROP INDEX [ScanSystemInfo].[IdScan]; PRE_SQL DROP INDEX [ScanSystemInfo].[Name]; PRE_SQL DROP INDEX [ScanSystemInfo].[Version]; PRE_SQL DROP INDEX [ScanSystemInfo].[Compilation]; PRE_SQL DROP INDEX [ScanSystemInfo].[ProductKey]; PRE_SQL DROP INDEX [ScanRegInfo].[IdScan]; PRE_SQL DROP INDEX [ScanRegInfo].[NoPrint]; PRE_SQL DROP INDEX [ScanRegComponent].[IdReg]; PRE_SQL DROP INDEX [ScanRegComponent].[Path]; PRE_SQL DROP INDEX [ScanFileGroup].[IdScan]; PRE_SQL DROP INDEX [ScanFileGroup].[Name]; PRE_SQL DROP INDEX [ScanFileInfo].[IdScan]; PRE_SQL DROP INDEX [ScanFileInfo].[IdGroup]; PRE_SQL DROP INDEX [ScanFileInfo].[NoPrint]; PRE_SQL DROP INDEX [ScanFileInfo].[Name]; PRE_SQL DROP INDEX [ScanFileInfo].[Path]; PRE_SQL DROP INDEX [ScanFileInfo].[Type]; PRE_SQL DROP INDEX [ScanFileInfo].[FileSize]; PRE_SQL DROP INDEX [ScanFileInfo].[Created]; PRE_SQL DROP INDEX [ScanFileInfo].[Accessed]; PRE_SQL DROP INDEX [ScanFileInfo].[Wrote]; PRE_SQL DROP INDEX [ScanFileInfo].[IdIcon]; PRE_SQL DROP INDEX [UnknownApp].[ExeName]; PRE_SQL DROP INDEX [UnknownApp].[CompanyName]; PRE_SQL DROP INDEX [UnknownApp].[FileVersion]; PRE_SQL DROP INDEX [UnknownApp].[FileDescription]; PRE_SQL DROP INDEX [UnknownApp].[NoVersion]; PRE_SQL DROP INDEX [UnknownApp].[CRC]; PRE_SQL DROP INDEX [UnknownApp].[MD5]; PRE_SQL DROP INDEX [UnknownApp].[IdIcon]; PRE_SQL ALTER TABLE [UserGroup] DROP CONSTRAINT Network_UserGroup; PRE_SQL ALTER TABLE [User] DROP CONSTRAINT UserGroup_User; PRE_SQL ALTER TABLE [WebSession] DROP CONSTRAINT User_WebSession; PRE_SQL ALTER TABLE [WebTime] DROP CONSTRAINT WebSession_WebTime; PRE_SQL ALTER TABLE [Rights] DROP CONSTRAINT User_Rights; PRE_SQL ALTER TABLE [WinSession] DROP CONSTRAINT User_WinSession; PRE_SQL ALTER TABLE [AppSessionSum] DROP CONSTRAINT WinSession_AppSessionSum; PRE_SQL ALTER TABLE [AppSession] DROP CONSTRAINT WinSession_AppSession; PRE_SQL ALTER TABLE [ScanResult] DROP CONSTRAINT User_ScanResult; PRE_SQL ALTER TABLE [ScanAppInfo] DROP CONSTRAINT ScanResult_ScanAppInfo; PRE_SQL ALTER TABLE [ScanAppInfo] DROP CONSTRAINT Icon_ScanAppInfo; PRE_SQL ALTER TABLE [UnknownAppInfo] DROP CONSTRAINT ScanResult_UnknownAppInfo; PRE_SQL ALTER TABLE [UnknownAppInfo] DROP CONSTRAINT Icon_UnknownAppInfo; PRE_SQL ALTER TABLE [ScanSystemInfo] DROP CONSTRAINT ScanResult_ScanSystemInfo; PRE_SQL ALTER TABLE [ScanRegInfo] DROP CONSTRAINT ScanRes_ScanRegInfo; PRE_SQL ALTER TABLE [ScanRegComponent] DROP CONSTRAINT ScanRegInfo_ScanRegComponent; PRE_SQL ALTER TABLE [ScanFileGroup] DROP CONSTRAINT ScanResult_ScanFileGroup; PRE_SQL ALTER TABLE [ScanFileInfo] DROP CONSTRAINT ScanFileGroup_ScanFileInfo; PRE_SQL ALTER TABLE [ScanFileInfo] DROP CONSTRAINT Icon_ScanFileInfo; PRE_SQL ALTER TABLE [UnknownApp] DROP CONSTRAINT Icon_UnknownApp; COPY TABLE [_Anubis_Master_2000_] WITHOUT [Id]; COPY TABLE [AppAlias] WITHOUT [Id]; COPY TABLE [Fingerprint] WITHOUT [Id]; COPY TABLE [Licenses] WITHOUT [Id]; COPY TABLE [Rights] WITHOUT [Id] IDENTITY [Id] RESTORE [IdUser] FROM [User]; COPY TABLE [Network] WITHOUT [Id] IDENTITY [Id]; COPY TABLE [UserGroup] WITHOUT [Id] IDENTITY [Id] RESTORE [IdNetwork] FROM [Network]; COPY TABLE [User] WITHOUT [Id] IDENTITY [Id] RESTORE [IdGroup] FROM [UserGroup]; COPY TABLE [Icon]; COPY TABLE [KnownApp]; COPY TABLE [WinSession] WITHOUT [Id] IDENTITY [Id] RESTORE [IdUser] FROM [User]; COPY TABLE [AppSessionSum] WITHOUT [Id] IDENTITY [Id] RESTORE [IdSession] FROM [WinSession], [IdApp] FROM [App]; COPY TABLE [App] WITHOUT [Id] IDENTITY [Id]; COPY TABLE [AppSession] WITHOUT [Id] IDENTITY [Id] RESTORE [IdSession] FROM [WinSession], [IdApp] FROM [App]; COPY TABLE [WebSession] WITHOUT [Id] IDENTITY [Id] RESTORE [IdUser] FROM [User]; COPY TABLE [WebTime] WITHOUT [Id] IDENTITY [Id] RESTORE [IdSession] FROM [WebSession], [IdSite] FROM [WebSite]; COPY TABLE [WebSite] WITHOUT [Id] IDENTITY [Id]; COPY TABLE [ScanResult] WITHOUT [Id] IDENTITY [Id] RESTORE [IdUser] FROM [User]; COPY TABLE [ScanAppInfo] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult], [IdPacket] FROM [ScanRegInfo]; COPY TABLE [UnknownAppInfo] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult], [IdApp] FROM [UnknownApp], [IdPacket] FROM [ScanRegInfo]; COPY TABLE [ScanSystemInfo] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult]; COPY TABLE [ScanRegInfo] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult]; COPY TABLE [ScanRegComponent] WITHOUT [Id] IDENTITY [Id] RESTORE [IdReg] FROM [ScanRegInfo]; COPY TABLE [ScanFileGroup] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult]; COPY TABLE [ScanFileInfo] WITHOUT [Id] IDENTITY [Id] RESTORE [IdScan] FROM [ScanResult], [IdGroup] FROM [ScanFileGroup]; COPY TABLE [UnknownApp] WITHOUT [Id] IDENTITY [Id]; POST_SQL CREATE UNIQUE INDEX [Name] ON [AppAlias] ( [Name] ); POST_SQL CREATE INDEX [Alias] ON [AppAlias] ( [Alias] ); POST_SQL CREATE UNIQUE INDEX [Version] ON [Fingerprint] ( [Version] ); POST_SQL CREATE UNIQUE INDEX [IdApp] ON [Licenses] ( [IdApp] ); POST_SQL CREATE INDEX [Licenses] ON [Licenses] ( [Licenses] ); POST_SQL CREATE INDEX [Company] ON [Licenses] ( [Company] ); POST_SQL CREATE INDEX [Application] ON [Licenses] ( [Application] ); POST_SQL CREATE UNIQUE INDEX [Main] ON [Licenses] ( [Company], [Application] ); POST_SQL CREATE UNIQUE INDEX [Name] ON [Network] ( [Name] ); POST_SQL CREATE INDEX [IP] On Network ( [IP] ); POST_SQL CREATE INDEX [Mask] On Network ( [Mask] ); POST_SQL CREATE INDEX [IdNetwork] ON [UserGroup] ( [IdNetwork] ); POST_SQL CREATE INDEX [Name] ON [UserGroup] ( [Name] ); POST_SQL CREATE INDEX [Default] ON [UserGroup] ( [Default] ); POST_SQL CREATE UNIQUE INDEX [Main] ON [UserGroup] ( [Name], [IdNetwork] ); POST_SQL CREATE INDEX [IdGroup] ON [User] ( [IdGroup] ); POST_SQL CREATE INDEX [Name] ON [User] ( [Name] ); POST_SQL CREATE INDEX [IP] ON [User] ( [IP] ); POST_SQL CREATE INDEX [Host] ON [User] ( [Host] ); POST_SQL CREATE INDEX [GUID] ON [User] ( [GUID] ); POST_SQL CREATE INDEX [LastScan] ON [User] ( [LastScan] ); POST_SQL CREATE INDEX [System] ON [User] ( [System] ); POST_SQL CREATE INDEX [Password] ON [User] ( [Password] ); POST_SQL CREATE INDEX [NoNet] ON [User] ( [NoNet] ); POST_SQL CREATE INDEX [DNSName] ON [User] ( [DNSName] ); POST_SQL CREATE INDEX [Mac] ON [User] ( [Mac] ); POST_SQL CREATE INDEX [IdUser] ON [WebSession] ( [IdUser] ); POST_SQL CREATE INDEX [Start] ON [WebSession] ( [Start] ); POST_SQL CREATE INDEX [UserName] ON [WebSession] ( [UserName] ); POST_SQL CREATE INDEX [IdSession] ON [WebTime] ( [IdSession] ); POST_SQL CREATE INDEX [IdSite] ON [WebTime] ( [IdSite] ); POST_SQL CREATE INDEX [Start] ON [WebTime] ( [Start] ); POST_SQL CREATE INDEX [WorkTime] ON [WebTime] ( [WorkTime] ); POST_SQL CREATE UNIQUE INDEX [URL] ON [WebSite] ( [URL] ); POST_SQL CREATE INDEX [Title] ON [WebSite] ( [Title] ); POST_SQL CREATE INDEX [IdUser] ON [Rights] ( [IdUser] ); POST_SQL CREATE INDEX [IdApp] ON [Rights] ( [IdApp] ); POST_SQL CREATE UNIQUE INDEX [Main] ON [Rights] ( [IdApp], [IdUser] ); POST_SQL CREATE INDEX [IdUser] ON [WinSession] ( [IdUser] ); POST_SQL CREATE INDEX [Start] ON [WinSession] ( [Start] ); POST_SQL CREATE INDEX [Exit] ON [WinSession] ( [Exit] ); POST_SQL CREATE INDEX [UserName] ON [WinSession] ( [UserName] ); POST_SQL CREATE INDEX [KeyCount] ON [WinSession] ( [KeyCount] ); POST_SQL CREATE INDEX [ClickCount] ON [WinSession] ( [ClickCount] ); POST_SQL CREATE INDEX [Active] ON [WinSession] ( [Active] ); POST_SQL CREATE INDEX [TotalTime] ON [WinSession] ( [TotalTime] ); POST_SQL CREATE INDEX [IdSession] ON [AppSessionSum] ( [IdSession] ); POST_SQL CREATE INDEX [KeyCount] ON [AppSessionSum] ( [KeyCount] ); POST_SQL CREATE INDEX [ClickCount] ON [AppSessionSum] ( [ClickCount] ); POST_SQL CREATE INDEX [TotalTime] ON [AppSessionSum] ( [TotalTime] ); POST_SQL CREATE INDEX [ActiveTime] ON [AppSessionSum] ( [ActiveTime] ); POST_SQL CREATE INDEX [ForeTime] ON [AppSessionSum] ( [ForeTime] ); POST_SQL CREATE INDEX [Activity] ON [AppSessionSum] ( [Activity] ); POST_SQL CREATE INDEX [IdApp] ON [AppSessionSum] ( [IdApp] ); POST_SQL CREATE UNIQUE INDEX [Name] ON [App] ( [Name] ); POST_SQL CREATE INDEX [Alias] ON [App] ( [Alias] ); POST_SQL CREATE INDEX [IdSession] ON [AppSession] ( [IdSession] ); POST_SQL CREATE INDEX [Start] ON [AppSession] ( [Start] ); POST_SQL CREATE INDEX [Exit] ON [AppSession] ( [Exit] ); POST_SQL CREATE INDEX [StartTick] ON [AppSession] ( [StartTick] ); POST_SQL CREATE INDEX [IdProcess] ON [AppSession] ( [IdProcess] ); POST_SQL CREATE INDEX [TotalTime] ON [AppSession] ( [TotalTime] ); POST_SQL CREATE INDEX [ActiveTime] ON [AppSession] ( [ActiveTime] ); POST_SQL CREATE INDEX [DeadTime] ON [AppSession] ( [DeadTime] ); POST_SQL CREATE INDEX [Activity] ON [AppSession] ( [Activity] ); POST_SQL CREATE INDEX [KeyCount] ON [AppSession] ( [KeyCount] ); POST_SQL CREATE INDEX [ClickCount] ON [AppSession] ( [ClickCount] ); POST_SQL CREATE INDEX [IdApp] ON [AppSession] ( [IdApp] ); POST_SQL CREATE UNIQUE INDEX [Id] ON [KnownApp] ( [Id] ); POST_SQL CREATE INDEX [Company] ON [KnownApp] ( [Company] ); POST_SQL CREATE INDEX [Name] ON [KnownApp] ( [Name] ); POST_SQL CREATE INDEX [Version] ON [KnownApp] ( [Version] ); POST_SQL CREATE INDEX [ExeName] ON [KnownApp] ( [ExeName] ); POST_SQL CREATE INDEX [Main] ON [KnownApp] ( [Company], [Name], [Version] ); POST_SQL CREATE INDEX [IdUser] ON [ScanResult] ( [IdUser] ); POST_SQL CREATE INDEX [Date] ON [ScanResult] ( [Date] ); POST_SQL CREATE INDEX [Mode] ON [ScanResult] ( [Mode] ); POST_SQL CREATE INDEX [IdScan] ON [ScanAppInfo] ( [IdScan] ); POST_SQL CREATE INDEX [IdApp] ON [ScanAppInfo] ( [IdApp] ); POST_SQL CREATE INDEX [AppPath] ON [ScanAppInfo] ( [AppPath] ); POST_SQL CREATE INDEX [NoPrint] ON [ScanAppInfo] ( [NoPrint] ); POST_SQL CREATE INDEX [Omit] ON [ScanAppInfo] ( [Omit] ); POST_SQL CREATE INDEX [IdPacket] ON [ScanAppInfo] ( [IdPacket] ); POST_SQL CREATE INDEX [IdIcon] ON [ScanAppInfo] ( [IdIcon] ); POST_SQL CREATE INDEX [IdScan] ON [UnknownAppInfo] ( [IdScan] ); POST_SQL CREATE INDEX [IdApp] ON [UnknownAppInfo] ( [IdApp] ); POST_SQL CREATE INDEX [Path] ON [UnknownAppInfo] ( [Path] ); POST_SQL CREATE INDEX [NoPrint] ON [UnknownAppInfo] ( [NoPrint] ); POST_SQL CREATE INDEX [Omit] ON [UnknownAppInfo] ( [Omit] ); POST_SQL CREATE INDEX [IdPacket] ON [UnknownAppInfo] ( [IdPacket] ); POST_SQL CREATE INDEX [IdIcon] ON [UnknownAppInfo] ( [IdIcon] ); POST_SQL CREATE INDEX [IdScan] ON [ScanSystemInfo] ( [IdScan] ); POST_SQL CREATE INDEX [Name] ON [ScanSystemInfo] ( [Name] ); POST_SQL CREATE INDEX [Version] ON [ScanSystemInfo] ( [Version] ); POST_SQL CREATE INDEX [Compilation] ON [ScanSystemInfo] ( [Compilation] ); POST_SQL CREATE INDEX [ProductKey] ON [ScanSystemInfo] ( [ProductKey] ); POST_SQL CREATE INDEX [IdScan] ON [ScanRegInfo] ( [IdScan] ); POST_SQL CREATE INDEX [NoPrint] ON [ScanRegInfo] ( [NoPrint] ); POST_SQL CREATE INDEX [IdReg] ON [ScanRegComponent] ( [IdReg] ); POST_SQL CREATE INDEX [Path] ON [ScanRegComponent] ( [Path] ); POST_SQL CREATE INDEX [IdScan] ON [ScanFileGroup] ( [IdScan] ); POST_SQL CREATE INDEX [Name] ON [ScanFileGroup] ( [Name] ); POST_SQL CREATE INDEX [IdScan] ON [ScanFileInfo] ( [IdScan] ); POST_SQL CREATE INDEX [IdGroup] ON [ScanFileInfo] ( [IdGroup] ); POST_SQL CREATE INDEX [NoPrint] ON [ScanFileInfo] ( [NoPrint] ); POST_SQL CREATE INDEX [Name] ON [ScanFileInfo] ( [Name] ); POST_SQL CREATE INDEX [Path] ON [ScanFileInfo] ( [Path] ); POST_SQL CREATE INDEX [Type] ON [ScanFileInfo] ( [Type] ); POST_SQL CREATE INDEX [FileSize] ON [ScanFileInfo] ( [SizeHigh], [SizeLow] ); POST_SQL CREATE INDEX [Created] ON [ScanFileInfo] ( [Created] ); POST_SQL CREATE INDEX [Accessed] ON [ScanFileInfo] ( [Accessed] ); POST_SQL CREATE INDEX [Wrote] ON [ScanFileInfo] ( [Wrote] ); POST_SQL CREATE INDEX [IdIcon] ON [ScanFileInfo] ( [IdIcon] ); POST_SQL CREATE INDEX [ExeName] ON [UnknownApp] ( [ExeName] ); POST_SQL CREATE INDEX [CompanyName] ON [UnknownApp] ( [CompanyName] ); POST_SQL CREATE INDEX [FileVersion] ON [UnknownApp] ( [FileVersion] ); POST_SQL CREATE INDEX [FileDescription] ON [UnknownApp] ( [FileDescription] ); POST_SQL CREATE INDEX [NoVersion] ON [UnknownApp] ( [NoVersion] ); POST_SQL CREATE INDEX [CRC] ON [UnknownApp] ( [CRC] ); POST_SQL CREATE INDEX [MD5] ON [UnknownApp] ( [MD5] ); POST_SQL CREATE INDEX [IdIcon] ON [UnknownApp] ( [IdIcon] ); POST_SQL ALTER TABLE [UserGroup] ADD CONSTRAINT Network_UserGroup FOREIGN KEY ( [IdNetwork] ) REFERENCES [Network] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [User] ADD CONSTRAINT UserGroup_User FOREIGN KEY ( [IdGroup] ) REFERENCES [UserGroup] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [WebSession] ADD CONSTRAINT User_WebSession FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [WebTime] ADD CONSTRAINT WebSession_WebTime FOREIGN KEY ( [IdSession] ) REFERENCES [WebSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [Rights] ADD CONSTRAINT User_Rights FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [WinSession] ADD CONSTRAINT User_WinSession FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [AppSessionSum] ADD CONSTRAINT WinSession_AppSessionSum FOREIGN KEY ( [IdSession] ) REFERENCES [WinSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [AppSession] ADD CONSTRAINT WinSession_AppSession FOREIGN KEY ( [IdSession] ) REFERENCES [WinSession] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanResult] ADD CONSTRAINT User_ScanResult FOREIGN KEY ( [IdUser] ) REFERENCES [User] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanAppInfo] ADD CONSTRAINT ScanResult_ScanAppInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanAppInfo] ADD CONSTRAINT Icon_ScanAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; POST_SQL ALTER TABLE [UnknownAppInfo] ADD CONSTRAINT ScanResult_UnknownAppInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [UnknownAppInfo] ADD CONSTRAINT Icon_UnknownAppInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanSystemInfo] ADD CONSTRAINT ScanResult_ScanSystemInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanRegInfo] ADD CONSTRAINT ScanRes_ScanRegInfo FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanRegComponent] ADD CONSTRAINT ScanRegInfo_ScanRegComponent FOREIGN KEY ( [IdReg] ) REFERENCES [ScanRegInfo] ( [Id] )ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanFileGroup] ADD CONSTRAINT ScanResult_ScanFileGroup FOREIGN KEY ( [IdScan] ) REFERENCES [ScanResult] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanFileInfo] ADD CONSTRAINT ScanFileGroup_ScanFileInfo FOREIGN KEY ( [IdGroup] ) REFERENCES [ScanFileGroup] ( [Id] ) ON DELETE CASCADE ON UPDATE CASCADE; POST_SQL ALTER TABLE [ScanFileInfo] ADD CONSTRAINT Icon_ScanFileInfo FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; POST_SQL ALTER TABLE [UnknownApp] ADD CONSTRAINT Icon_UnknownApp FOREIGN KEY ( [IdIcon] ) REFERENCES [Icon] ( [Id] ) ON UPDATE CASCADE; </SQL_COPY_DATABASE>